Wed, 11 Feb 2019
What to do if you get an "incorrect bookmark ordinal" error when using SQL Server with our Oracle ODBC Driver
If you use a four part query in SQL Server such as:
SELECT * FROM ORACLEWP..SYSTEM.CONTACTS
you 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.