Oracle 9i as a linked server

[martynh]

We are trying to connect Oracle 9i as a linked server. We have to use the Oracle OLE Provider for Oracle, because the Microsoft OLE Provider (MSDAORA) uses 8i dll's.

When we try to run test queries through Query Analyser we get the error message:

Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

This happened with 8i as well, but we got around it by using the MS supplied provider. This isn't an option now. Has anyone got any solutions?

Thanks

Martyn

 

[karluk]

If you haven't actually tested the Microsoft OLE Provider, I would do so. I would expect it to work just fine connecting to an Oracle 9i database. The fact that it uses 8i dll's shouldn't make any difference. That's just Oracle client components, and Oracle 8i client can connect to Oracle 9i server.

 

[lisali]

Has anyone made figured this out yet? I'm having the same problem, and I'm using Microsoft OLE DB Provider for Oracle, my oracle database is in 9i too. What's interesting is, I have two schema owners in the database, right now, queries againt tables in one schema work fine, while the other don't. Any suggestion?
Thanks.