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
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.