Linked SQL Server to Oracle
- by Jerid
Getting this error when executing SQL Server query only when connected via remote Desktop.
When running the query from desktop, no problem. Is this a tsnNames issue?
Linked server to Oracle 9i
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: ORA-01041: internal error. hostdef extension doesn't exist
]
OLE DB error trace [OLE/DB Provider 'MSDAORA' ICommandText::Execute returned 0x80004005: ].