• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

error involving 64-bit windows 7, can't figure it out

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello all,

I've been working on a program for one of my classes, and I keep running into this same error. After doing some research I found that the problem lays in my OS's initial compatibility with Microsoft Access.

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

Now, I've already tried a couple different things to try and fix this (I'll list what I've tried below), but to no avail. I am sure that there has to be someone else out there who has experienced a problem like this before but managed to solve it. (I'm running Windows 7 64-bit Professional Edition.)

1) installing the 64-bit drivers for Microsoft Access (this fails and brings up an error saying that I must first uninstall my 32-bit version first, but after I did more research, it turns out that the 64-bit
drivers are already installed on my computer, they are just hidden in the sysWOW64 folder)

2) redirecting the "Target" and "Start in: " folders to "%windir%\syswow64\odbcad32.exe" instead of the original folder, which only held the 32-bit drivers.

Thanks in advance for the help, it's greatly appreciated!
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can you check this thread about the same subject?
 
Kody Wright
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ah yes, well that was the first thing I did (#1). I called it the 64-bit driver, guess that's not the correct name lol. Unfortunately it changed nothing for me : (
 
reply
    Bookmark Topic Watch Topic
  • New Topic