Link server fro Oracle

I have two link servers set up on SQL server .I got errors when I run simple
select from Query Analyzer from one of the Oracle link server.

select * FROM abcd..abc.mytable1

Server: Msg 7317, Level 16, State 1, Line 1
OLE Database provider 'MSDAORA' returned an invalid schema definition.
OLE Database error trace [Non-interface error: OLE/DB provider returned an
invalid schema definition.].

Does abcd..abc.mytable1 have a desc order index? if so, it is not supported
by MSDAORA.

no. Oracle DBA fixed this by rebuilding a different table in the database.
and it worked.

That table was the only one caused the problem.


"John Barr" wrote:

> Does abcd..abc.mytable1 have a desc order index? if so, it is not supported
> by MSDAORA.
>
>
>