I cannot successfully set up an SQL Server linked server to my Progress 9.1D database using Merant 3.60 32-BIT PROGRESS ODBC Data source yet this data source works fine in DTS packages.
I would appreciate anyone's help in getting this problem solved, so I can use T-SQL statements such as SELECT * FROM OPENQUERY(...
When I try to display the Tables under the Linked Server in Enterprise manager, I get error message "Error 7399: OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
I would appreciate anyone's help in getting this problem solved, so I can use T-SQL statements such as SELECT * FROM OPENQUERY(...
When I try to display the Tables under the Linked Server in Enterprise manager, I get error message "Error 7399: OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].