I am using SQLServer 2000 linked server to connect to a vendors Progress Database. I have done this successfully before using the DATADIRECT 4.10 32-bit Progress SQL92 v9.1e driver provided by the vendor.
The vendor did an upgrade and required us to use the OpenEdge 10.0b driver and now I am not able to dee or query the tables. I setup a DSN for the connection and a test connect proves to be successful. In SQL Server when I attempt to view the table available I get error:
Error 7399: OLE DB provider 'MSDASQL' Reported an error.
Driver's SQLSetConnectAttr failed.
No Data
Optional feature not implemented
OLE db error trace [OLD/DB Provider 'MSDASQL' IDBInitialize returned 0x80004005
I was able to test out the driver using a MSAcces database and I see the tables and perform queries against them without an issue. Is there a particular setting on the progress side to allow SQL Server to connect or get data? I have checked and re-checked my settings. I hope someone out there has an idea or has experienced this before, I am desparate!
The vendor did an upgrade and required us to use the OpenEdge 10.0b driver and now I am not able to dee or query the tables. I setup a DSN for the connection and a test connect proves to be successful. In SQL Server when I attempt to view the table available I get error:
Error 7399: OLE DB provider 'MSDASQL' Reported an error.
Driver's SQLSetConnectAttr failed.
No Data
Optional feature not implemented
OLE db error trace [OLD/DB Provider 'MSDASQL' IDBInitialize returned 0x80004005
I was able to test out the driver using a MSAcces database and I see the tables and perform queries against them without an issue. Is there a particular setting on the progress side to allow SQL Server to connect or get data? I have checked and re-checked my settings. I hope someone out there has an idea or has experienced this before, I am desparate!