File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes ODBC connection problem in windows 7 x64 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ODBC connection problem in windows 7 x64 " Watch "ODBC connection problem in windows 7 x64 " New topic

ODBC connection problem in windows 7 x64

siva chaitanya
Ranch Hand

Joined: Jul 05, 2011
Posts: 59
The following error is coming when i used to connect with database

unable to connect to sql state 08004 oracle odbc ora ora-12154:TNS:could not resolve the connect identifier specified

I followed all the neccessary steps that to be followed but I can't able to figure out this error.

Please help me

Martin Vajsar

Joined: Aug 22, 2010
Posts: 3733

Do not use ODBC. Use an Oracle JDBC driver and connect using it (there are type 4 Oracle JDBC drivers, so there is absolutely no issue using them).

It might not immediately solve your problem, but it will eliminate ODBC (which is messy) from the picture. The rest will be considerably easier to solve. Also, there are other ODBC related incompatibilities and other problems that are best to be avoided.

We also have an Oracle FAQ page which might help you.
I agree. Here's the link:
subject: ODBC connection problem in windows 7 x64
It's not a secret anymore!