Home » Open Source » Programming Interfaces » Unable to connect using ODBC (3 Merged) (WINDOWS 2008 R2 64)
Unable to connect using ODBC (3 Merged) [message #550847] Thu, 12 April 2012 22:08 Go to next message
mjkreddy1927
Messages: 20
Registered: February 2007
Junior Member
Hi Friends,

i was trying to connect to my database through ODBC from windows 2008 R2 64 bit, when i am trying to test connection from ODBC, its giving me error.

I have attached the image of the error, please help me out.
Re: ODBC error [message #550850 is a reply to message #550847] Thu, 12 April 2012 22:20 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
Previous Topic: Reg sending mail with attachment with perl script
Next Topic: ODBC Driver not found
Goto Forum:
  


Current Time: Thu Mar 28 14:03:23 CDT 2024