Error Query Linked Server
Posted on 2007-11-23
I added a Linked Server - ODBC to a Progress DB in Enterprise Manager.
Query: Select * from erptest.pub.dbo.part
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider does not support the necessary method.
[OLE/DB provider returned message: Method is not supported by this provider.]
[OLE/DB provider returned message: [DataDirect-Technologies][ODBC PROGRESS driver]Optional feature not implemented.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80040e53: The provider does not support the necessary method.].