I have on SQL2008 server linked server Teradada. I select from this linked server and for many tables is ok, but
when I select some tables I see error:
OLE DB provider "MCDASQL" for linked server "TD" returned message "Multiple-step OLE DB operation generated errors. Chek each OLE DB status value, if available. No Work was done.
MSG 7311, Level 16, state 2, Line 1
Cannot obtain the schema rowset "DBSCHMA_INDEXES" for OLE DB provider "MSDASQL" for linked server "TD". The provider support the interface, ut returns a failure code it is used.
select * from TD.."001_SM_TABLE"."PAYNAME_ALL_FCT_NO" -- is executed ok and returns rows,
select * from TD.."001_SM_TABLE"."PAYNAME_GR_FCT" - is return error :(
When I select rows use Teradata SQL Asisstant both table is OK and I seee all rows
Please help if You have any ideas