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: ].
Here's the information for one of my connections:
Product name: Oracle Data source: xxxx.world Provider string: MSDAORA
I used the Oracle 9i driver for the DSN
Here's the tnsnames entry:
xxx.world = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (COMMUNITY=tcp.world) (PROTOCOL=tcp) (HOST=gvx0aidwh01p.xxxx.com) (PORT= 1521) ) ) (CONNECT_DATA= (SID=idwp5) ) )