Hi,
I have declared a DB2 linked server in SQL Server 7.0 and I get I list of tables by issuing EXEC sp_tables_ex linked.
However, when I attempt to access a table it fails with the following:
Server: Msg 7311, Level 16, State 2, Line 1
Could not obtain the schema rowset for OLE DB provider 'MSDASQL'. The provider supports the interface, but returns a failure code when it is used.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
Any suggestions?
I have declared a DB2 linked server in SQL Server 7.0 and I get I list of tables by issuing EXEC sp_tables_ex linked.
However, when I attempt to access a table it fails with the following:
Server: Msg 7311, Level 16, State 2, Line 1
Could not obtain the schema rowset for OLE DB provider 'MSDASQL'. The provider supports the interface, but returns a failure code when it is used.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
Any suggestions?