0 Replies Latest reply: Aug 18, 2013 4:13 AM by 0fa9d297-5c16-425f-a412-d5c4360706b1 RSS

    Problem with JDBC-ODBC bridge

    0fa9d297-5c16-425f-a412-d5c4360706b1

      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...