Part of the problem when working with linked servers is that SQL Server stores some of its information in the Window Registry, and can not easily be verified. The provider supports the interface, but returns a failure code when it is used. Cannot obtain the schema rowset "DBSCHEMA_INDEXES" for OLE DB provider "OraOLEDB.Oracle" for linked server "ORA". The provider reported an unexpected catastrophic failure.I have set this up on other servers, what did I forget to do? To troubleshoot, first I open up the provider. Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "ccbtst". The OLE DB provider "OraOLEDB.Oracle" for linked server "ccbtst" reported an error. I am providing you details of a linked server that is already created at my end. Create a linked Server Right click on the “Linked Server” node and select “New Linked Server…”.
The OLE DB provider “OraOLEDB.Oracle” for linked server “ERPPROD” returned a “NON-CLUSTERED and NOT INTEGRATED” index “XXFPPUNCHM_N1” with the incorrect bookmark ordinal 0.
0 kommentar(er)
