aspose file tools
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


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
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
Author

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
Sheriff

Joined: Aug 22, 2010
Posts: 3611
    
  60

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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ODBC connection problem in windows 7 x64