Hello,
I'm having problems creating a linked Progress database (10.2B03) in SQL server 2005 64 (9.0.405) on Windows 2003 64 SP2 using the Progress 64 bit ODBC driver, 5.30.00.98.
Creating the ODBC data source and successfully connect to the Progress database works fine.
Connecting to another linked server (MySQL) using it's 64 bit driver also works
Both linked servers are using MSDASQL
But when I'm trying to test the connection of the linked Progress server I get this error:
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "THEPDB".
OLE DB provider "MSDASQL" for linked server "THEPDB" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.".
OLE DB provider "MSDASQL" for linked server "THEPDB" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Access denied(Authorisation failed)".
OLE DB provider "MSDASQL" for linked server "THEPDB" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.". (.Net SqlClient Data Provider)
Anyone? Bueller?