I have an issues with linked server to Oracle...
at first the server running SQL Servre 2000 and Oracle8i, and the linked server works well...
But after IT Department installs an Oracle 11g Client on the server...
When I execute my open query in SQL Server, I get an error message
[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
Hope you guys can help me out, thanks.