This discussion is archived
0 Replies Latest reply: Aug 18, 2013 2:13 AM by 0fa9d297-5c16-425f-a412-d5c4360706b1 RSS

Problem with JDBC-ODBC bridge

0fa9d297-5c16-425f-a412-d5c4360706b1 Newbie
Currently Being Moderated

OS in my PC is Windows7 Ultimate(64-bit), and I had JDK1.7.0_21(compatible with my PC), Oracle 10G ExpressEdition(32-Bit), ApacheTomcat7.0.11(compatible with my PC).

As my OS is 64-BIT, I accessed C:\Windows\SysWOW64\odbcad32 and  I selected UserDSN tab->Add->Microsoft ODBC for Oracle->finish,tapply->ok. Then a Dialog Box appeared and I entered a DSN name=ramsdsn and my DATABASE USERID=rams in username->ok->apply->ok.

But when I tried to compile my program using:

      DriverManager.getConnection("jdbc:odbc:ramsdsn","rams","rams");

I got an error:java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Help me FRNZ.. I have been trying it for 7 days and I'm tired of it and I could not figured it yet...

THANKS in Advance...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points