July 5, 2012 at 3:23 pm
It has been three years since I touched Oracle.
What do you enter in the Server Name for an OLE DB Connection?
I get the following error:
The connection failed because of an error initializing provider. ORA-12154 TNS: Could not resolve the connect identifier specified.
I was thinking that my TNSNames.ora was the culprit but that is not the case.
I can connect using SQL Developer using TNS.
I used the TNSPing utility and that was successful.
Any ideas? I had found an article on MSSQLTips.com earlier but had to stop to work on another issue and I can't find it.
Any article would be cool
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 3:31 pm
Forgot to mention that it is SQL server 2008 R2 64 bit.
I had to install both the 32 bit 11g Oracle Client to work with BIDS and the 64 bit to work with SQL Server Agent.
I found the following article but I'm not sure about specifying the connection string.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 3:40 pm
What do I need to specify in the sqlnet.ora?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 5:26 pm
I forgot to mention that SQL Plus errors out:
ORA12560: TNS: Proptocol Adapter Error
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 5:38 pm
I'm looking for some guidance, where is the One and Only when you need him?:hehe:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 5:57 pm
Welsh,
You got two Oracle's clients installed, you should verify that all your tnsnames.ora files contains the entry for the server you are trying to reach, you mention that tnsping worked, on which client, 32 or 64? and what version of Oracle client (I am not sure how many Oracle clients are installed in your environment, just 32-64 or more)
I found this article: ORA-12154[/url]; you may visit Ask Tom web site, it has an extense knowledge base.
Cheers,
Hope this helps,
Rock from VbCity
July 5, 2012 at 6:03 pm
Both tnsnames are identical and I have two Client installations, one for 32 bit and another for 64 bit.
The TNSPing works for both installations.
BTW, BIDS uses the 32 bit.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 6:10 pm
The problem appears to more of an Oracle Configuration issue.
Therefore this post has been moved to:
http://www.sqlservercentral.com/Forums/Topic1325802-1044-1.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply