Linked Server Error 7399 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked Server Error 7399

Hi, I setup the linked server to oracle 815 database
when I click ‘tables’ under the linked server name
i am getting the error: error 7399 OLEDB provider ‘MSDAORA’ reported an error Srini
Related KBAhttp://support.microsoft.com/kb/q241267/
Create an ODBC Data Source to Oracle:
System DSN -> Add Oracle ODBC driver
Data Source Name = (Oracle Connect String – ex. ORACLE_PROD)
Description = (Oracle Connect String – ex. ORACLE_PROD)
Service Name = (Oracle Connect String – ex. ORACLE_PROD)
UserID = sqldba (Oracle User ID) Reboot
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>