Site navigation
If you use a four-part query in SQL Server such as:
SELECT * FROM ORACLEWP..SYSTEM.CONTACTSyou may, depending on the indexes defined on the target table, get the following OLE DB provider error:
The OLE DB provider "MSDASQL" for linked server "ORACLEWP" returned a "NON-CLUSTERED and NOT INTEGRATED" index "SYS_C0010082" with the incorrect bookmark ordinal 0.
To work around this error, go into the properties for the MSDASQL provider and un-check the Index as access path option. Then re-run your query.