File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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: 3433
    
  47

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: http://aspose.com/file-tools
 
subject: ODBC connection problem in windows 7 x64
 
Similar Threads
TNS protocol adapter error
JDBC conncetion through context.xml SID
Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...
javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist
inserting a integer value to oracle