I try to query a progress database from VB code developped in Access2000. My ODBC Connection is OK (I use it in Crystal Reports) but I can't see the contents of my table.
Here is the code I'm using :
Dim wrkODBC As Workspace
Dim conPubs As Connection
Dim qryP As QueryDef
Dim...
Thank you for your answer. I found the solution. I use the security option and i have create a linked server ( i'm not sure of my translation ...). The only problem I had is the "string connection". It's not clear in the ODBC connection, so I have to use a udl file
I've just installed SQL Server 2000 and I would like to connect it to my Progress Database. I try using the security option and adding a new linked server. But I can't use my ODBC connection (using the Merant SQL92 driver).
I'm sure my ODBC connection is good because I use it in Crystal Reports...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.