Good day everyone....
I have installed the OraOLEDB.Oracle Provider on 3 different servers, and have made a link server on all three.
On two of the machines, I am successful in retrieving data from the Oracle database. But, on the third machine, I receive this error:
Server: Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "employee_prod" reported an error. The provider did not give any information about the error.
Server: Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "tims2_prod".
On the machine which is generating the error, I can use SQL*Plus to connect to the remote database. I can also connect to the database using the "ODBC Data Source Administrator" when I create a system DSN. It would appear that the driver is installed and working correctly, but SQL Server can not access it.
I have also uninstalled/installed serveral times.
All of our servers are running W2003 Standard X64 with SQL Server 2005 Standard 64-bit Edition.
Does anyone have any suggestions?
Found the solution.... "Allow inprocess" has to be checked in the provider options.|||hi can you please send me the steps on how to stepup a connection to Oracle Database throught SQL Database.
I have created a linked server, but i keep getting an error message
OLE DB provider "OraOLEDB.Oracle" for linked server "DBCONN" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "DBCONN".
My tns string is Prooracle and the database is oracle and the Schema is HR
appreciate your help
|||I had the same symtoms and did the re install etc. The item was checked and I unchecked it and it now works. Something to do with triggering a change in settings ?
|||It works, thanks. by unchecking the "Allow inprocess" option.|||I spent some time to find the option. From SQL Server Management Studio-->Server Objects-->Linked Servers-->Providers-->MSDAORA, right click select properties.
No comments:
Post a Comment