The specified DSN contains an architecture mismatch between the Driver and Application JAVA

Question

I m trying to connect to a database made by MS Access using Java  but I cannot seem to manage  I am using ODBC and I m getting this exception   java sql SQLException   Microsoft  ODBC Driver Manager  The specified DSN contains an architecture mismatch between the Driver and Application  My Java   package javaapplication2   import java sql Statement  import java sql Connection  import java sql DriverManager  import java sql ResultSet  import java sql SQLException               author Owner     public class JavaApplication2                    param args the command line arguments                       public static void main String   args               TODO code application logic here         try               Class forName  sun jdbc odbc JdbcOdbcDriver                String sourceURL   new String  jdbc odbc myDatabase                System out println sourceURL               Connection dbConnection   DriverManager getConnection sourceURL  admin                    Statement myStmt    dbConnection createStatement                 String query    INSERT INTO People ID  Name  Surname  Age  Contact  Location  Course  VALUES                           1007   Elroy    Smith    33   21366688   Somewhere    somecourse                  myStmt executeUpdate query                ResultSet results   myStmt executeQuery  SELECT   FROM People                 while results next                                  System out print results getString 1                    System out print results getString 2                    System out print results getString 3                    System out println results getString 4                                results close                       catch ClassNotFoundException cnfe                        System out println cnfe                     catch SQLException sqle                        System out println sqle

User · Answer

There s an architecture mismatch  Your JDBC Driver and your JDK should be of the same architecture  If your using 32bit Driver and your JDK is 64bits  you would get that error   See this  Fix   Depends on your architecture   You will need 64-bit drivers if your Java is 64-bit    Download   http   www microsoft com downloads details aspx familyid C06B8369-60DD-4B64-A44B-84B371EDE16D amp displaylang en

User · Answer

Have you created the DSN first in Control Panel Administrative Tools ODBC System DSN  Name it same as  myDatabase  and if i is asking for locating the database access file specify the path using browse option  Once ur DSN will be created successfully you will be easily able to access ur DB

User · Answer

None of these did it for me  I did find the answer on MSDN  There were hints to it though  The architecture in the error is referring to 32 vs 64 bits  My solution was to find out which my app is running under  Access  which 2010 is 32b  I found this by looking in the Process tab of Task Manager where all 32b processes have   32 the end of their names  As was said  the control panel will launch the 64 bit version of ODBC from here  c  windows system32 odbcad32 exe  and the 32 bit version is here   c  windows sysWOW64 odbcad32 exe  easiest to copy and paste into run dialog   So I set up DSNs with names ending in 32 and 64 in each of the corresponding ODBC control panels  AKA Administrator  that pointed to the same thing  Then  I picked pick the correct one based on whether the app using it is 32b or 64b

User · Answer

I saw this answer and it worked for me   https   msdn microsoft com en-us library ms712362 28v vs 85 29 aspx  After you have installed an ODBC driver from the driver s setup program  you can define one or more data sources for it  The data source name  DSN  should provide a unique description of the data  for example  Payroll or Accounts Payable  The user and system data sources that are defined for all currently installed drivers are listed in the User DSN or System DSN tabs of the ODBC Data Source Administrator dialog box  The file data sources in a given directory are listed in the File DSN tab  the directory to be shown is entered in the Look in box in the File DSN tab  System CAPS noteNote  To manage a data source that connects to a 32-bit driver under 64-bit platform  use c  windows sysWOW64 odbcad32 exe  To manage a data source that connects to a 64-bit driver  use c  windows system32 odbcad32 exe  In Administrative Tools on a 64-bit Windows 8 operating system  there are icons for both the 32-bit and 64-bit ODBC Data Source Administrator dialog box   If you use the 64-bit odbcad32 exe to configure or remove a DSN that connects to a 32-bit driver  for example  Driver do Microsoft Access    mdb   you will receive the following error message   The specified DSN contains an architecture mismatch between the Driver and Application  To resolve this error  use the 32-bit odbcad32 exe to configure or remove the DSN   A data source associates a particular ODBC driver with the data you want to access through that driver  For example  you might create a data source to use the ODBC dBASE driver to access one or more dBASE files found in a specific directory on your hard disk or a network drive  Using the ODBC Data Source Administrator  you can add  modify  and delete data sources  as described in the following table

User · Answer

If you are using netbeans go to tools-  java Platform  change jdk home  which points to c  programfiles java jdk1 7 to c programFiles x86  java jdk1 6 21  if not editable  find netbeans cnf and make change as stated abouve for jdk home  restart neatbeans and how it works I had the same problem   but i worked

User · Answer

I ran into this problem when upgrading to a windows 7 server with some legacy CLASP applications  Trying to run a 32bit application on a 64 bit machine   Try setting the application pools 32bit compatibility to True and or create dsn s in 32 and 64 bit    Open the odbc datasource window in both versions from the run box  C  Windows SysWOW64 odbcad32 exe C  Windows system32 odbcad32 exe

User · Answer

I have fixed the error   Follow the steps    Install JDK of 32bt version Install MS-Office 2007  Configure Control Panel     a  Control Panel b  Administrator Tools c  Data Source  ODBC   right click on it change the target to  sysWOW64 odbcad32 exe change the start in to r  SysWOW64   Execute it and Best Luck  Works in windows 7 as well as 8  Remove Newer version of MS-Office and install only MS-Office 2007 if problem still persists

User · Answer

By default  the Command Prompt is connected to System32   Run a 64-bit command prompt  i e   C  WINDOWS SYSWOW64 CMD EXE   In that  compile and run your java application

User · Answer

I had a great deal of trouble linking to MySQL from a 64 bit laptop  running Windows 7  using MS Access 2010   I found the previous article very helpful  but still could not connect using odbc 3 5 1   As I had previously linked a 32 bit machine using Connector ODBC 5 1 13  I downloaded that version and set it up using the instructions above   Success  The answer seems to be to try different versions of Connector odbc

User · Answer

To solve this problem first make sure that your java software should be 32bit version if it is 64 bit version clearly it will show the mismatch error so try to re-install 32bit of java version And execute the java program in the command of  c  windows sysWOW64 odbcad32 exe  easiest to copy and paste into run dialog  that s enough your program definitely work

User · Answer

Go to this link and download ODBC Driver for 64 bits OS   http   www microsoft com en-us download details aspx id 13255

User · Answer

I did encounter this problem  This is due to you computer architecture and the database architecture you are using   If you re using 32 bits operating system then everything works well because you can only install 32 bits software  Problem comes when you re using the 64 bits operating system   In order to solve this problem is simple - I took long time to discover this issue    Knowing your Operating System is 64 bits but your Microsoft Office is 32 bits  So in order for you to access your database using NetBean IDE  assuming you re using this   you need to install 32 bits JDK  If you have installed 64 bits  you have to uninstall it and install the 32 bits     You re unable to access your database because your 64 bits JVM is not the same as 32 bit JVM   To add your database into your system 1  Control Panel 2  Administrator Tools 3  Data Source  ODBC  right click on it change the target to   sysWOW64 odbcad32 exe change the start in to  r  SysWOW64  Then you should be able to run  Inform me if you have any problem with this    Thank you

User · Answer

A little late  but since I ve run into the same problem  in your exact scenario  I figured I d add my solution   I have Windows 7  64-bit  and Office 2010  32-bit   I tried with the DSN-less connection string   jdbc odbc Driver  Microsoft Access Driver    mdb    accdb   DBQ I  TeamForge ORS CTFORS accdb   and I tried with the DSN connection  using both the System32 and SysWOW64 versions of the ODBC Admin  and none of that worked   What finally worked  was to match the bit version of Java with the bit version of Office  Once I did that  I could use either the DSN or DSN less connection mode  without any fuss

User · Answer

i think this also will be more helpfull   for the architecture miss match   i just copy the jdk file from the 32 bit file  C  Program Files  x86  Java jdk1 7 0 71 and paste it to the 64 bit file  C  Program Files Java jdk1 7 0 10  then rename the file to match the file you replace to avoid the IDE error netbeans   then your good to go   note  You should buckup you 64bit files so when you want to create 64 bit application you can return it to its location

User · Answer

If you are connecting from a 64-bit platform using a 32-bit driver  then run the executable C  Windows SysWOW64 odbcad32 exe and create the DSN  It will work

User · Answer

To solve this problem first make sure that your java software should be 32bit version if it is 64 bit version clearly it will show the mismatch error so try to re-install 32bit of java version And execute the java program in the command of  c  windows sysWOW64 odbcad32 exe  easiest to copy and paste into run dialog  that s enough your program definitely work

User · Answer

You get this exact same error when trying to connect to a MySQL database from MS-Access when the bit version  32 vs 64  of Access doesn t match    the bit version of the ODBC Driver you are using the bit version of the ODBC Manager you used to set it up    For those of you trying to connect MS-Access to MySQL on a 64 bit Windows system  I went through sheer torture trying to get it to work with both MS-Access 2010 and MS-Access 2013   Finally got it working  and here are the lessons I ve learned along the way   I bought a new Windows 7  64 bit laptop  and I have an app which relies on MS-Access using MySQL tables    I installed the latest version of MySQL  5 6  using the All In One package install   This allows you to install both the database and ODBC drivers all at once   That s nice  but the ODBC driver it installs seems to be the 64 bit one  so it will not work with 32 bit MS-Access   It also seems a little buggy - not for sure on that one   When you Add a new DSN in the ODBC Manager  this driver appears as  Microsoft ODBC For Oracle    I could not get this one to work   I had to install the 32 bit one  discussed below    MySQL was working fine after the install   I restored my application MySQL database in the usual way   Now I want to connect to it using MS-Access     I had previously installed Office 2013  which I assumed was 64 bit   But upon checking the version  File  Account  About Access   I see that it is 32 bit   Both Access 2010 and 2013 are most commonly sold as 32-bit versions  My machine is a 64 bit machine   So by default  when you go to set up your DSN s for MS-Access  and go in the usual way into the ODBC Manager via Control Panel  Administrative Options   you get the 64 bit ODBC manager  You have no way of knowing that  You just can t tell   This is a huge gotcha    It is impossible to set up a DSN from there and have it successfully connect to MS Access 32 bit   You will get the dreaded error       the specified dsn contains an architecture mismatch      You must download and install the 32 bit ODBC driver from MySQL   I used version 3 5 1  http   dev mysql com downloads connector odbc 3 51 html You must tell the ODBC Manager in Control Panel to take a hike and must instead explicitly invoke the 32 bit ODBC Manager with this command executed at the Start  Command prompt      c  windows sysWOW64 odbcad32 exe   I created a shortcut to this on my desktop   From here  build your DSN with this manager  Important point   BUILD THEM AS SYSTEM DSNS  NOT USER DSNS   This tripped me up for awhile   By the way  the 64 bit version of the ODBC Manager can also be run explicitly as      c  windows system32 odbcad32 exe  Once you ve installed the 32-bit ODBC Driver from MySql  when you click Add in the ODBC Manager you will see 2 drivers listed   Choose  MySQL ODBC 5 2 ANSI Driver    I did not try the UNICODE driver      That does it   Once you have defined your DSN s in the 32 bit ODBC manager  you can connect to MySQL in the usual way from within Access - External Data  ODBC Database  Link to the Database  select Machine Data Source  and the DSN you created to your MySQL database will be there

User · Answer

The problem you were facing might be because  you were having Office 32 bit and Command Prompt 64 bit  To solve the problem you need to follow 2 steps    Open ODBC Manager for DSN using   C  Windows SysWOW64 odbcad32 exe This will open the ODBC Data Administrator for 32 bit version and you will see all the database drivers  After this you need to open the 32 bit command prompt using  C  Windows SysWOW64 cmd exe This will open the 32 bit version of command prompt  In this new CMD please recompile your Java program and run your program    Hope this will help

[java] The specified DSN contains an architecture mismatch between the Driver and Application. JAVA

Examples related to java

Examples related to odbc