Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 It's me again more problems with that darn...

Author  Topic 

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-06-15 : 18:38:31
Oracle Linked server.

It seems that SQL Server 7 and Oracle 8.1.5 just don't get along together when they see me.

When I check the INDEX AS ACCESS PATH option in the linked server properties I get the following error message (I have tried both the MS and ORACLE provided OLE drivers):

Server: Msg 7319, Level 16, State 1, Line 2
OLE DB provider 'OraOLEDB.Oracle' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'IDX_MMLOAN_LOANNUMBER' with incorrect bookmark ordinal 0.


What's this all about? I can't find anything on this error...


Daniel
SQL Server DBA
   

- Advertisement -