all groups > sql server connect > december 2004 >
You're in the

sql server connect

group:

Error 7317 when Accessing Linked Oracle Server



Error 7317 when Accessing Linked Oracle Server Bill Manring
12/29/2004 10:31:03 AM
sql server connect: I have a linked server to an Oracle 8i database. When I attempt to query the
Oracle tables I get the following error:

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

The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.

I would appreciate any help you could offer.



--
Thanks,

Bill Manring
Chief Software Architect
RE: Error 7317 when Accessing Linked Oracle Server Bill Manring
12/29/2004 11:51:01 AM
I found an answer to this problem so I thought I should post it in case
anyone else has a similar problem.

If I execute the query using the OPENQUERY function, the query executes
properly. Since OPENQUERY is a peferred way of querying linked srevers
anyway, there really is no problem.

[quoted text, click to view]
AddThis Social Bookmark Button