The client software is installed and seems to be working fine (Used access to link some tables). I set the product name to Oracle 8.1 and the Datasource to the system dns name. I left provider string, location and catalog blank. Under the security tab I had it set to map to the oracle account and also tried the impersonate option, but always got the same error.
Error: 7399 OLE DB provider 'MSDASQL' reported an error. Driver's SQLSetConnectAttr failed]
ORA-12640: Authentication Adapter initialization failed]
This is my first time trying to set up and Oracle database as a linked server, any help is appreciated.Made a few changes and now getting the following error.
"Error 7399: OLE DB provider 'MSDAORA' reported an error"
I get this error when trying to view the list of tables under the linked server in enterprise manager. When i run a basic query through query analyzer, i get this expanded error message.
"OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name"
Using Oracle ODBC Test utility in the Oracle client I am able to connect to the database and run queries.|||The most common problem in using Linked Server and other distributed services is SQL Server Agent did not have Network permissions which means your SQL Server is installed with the Microsoft provided local systems account, I maybe wrong but I think in 7.0 you may have to reinstall SQL Server with a Service account. You may not find the info about service account in SQL Server 7.0 BOL(books Online) because it took a while to get Microsoft to require the Service account. Hope This helps.
Kind regards,
Gift Peddie|||The error I would get is the following. "OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name".
I haven't been able to find a good step by step guide to follow to link to an Oracle database. Trying to reinstall the server might not be an option. If I could find something that did say it was the problem you mentioned, then it would probably be worth it.
Can anyone shed some light on this problem. Or managed to link to an oracle databse from SQL?|||Try these two urls, the first has most known SQL Server Errors and the solutions complined over the years by Neil Pikes and the second is one of the best Oracle info site on the Web including Oracle BOL(Books online). Hope this helps.
http://www.mssqlserver.com/faq
http://www.dbasupport.com
kind regards,
Gift Peddie
No comments:
Post a Comment