wood burning stoves*
The moose likes JDBC and the fly likes Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch..." Watch "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch..." New topic
Author

Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...

Azeem Mohammed
Greenhorn

Joined: Jan 15, 2009
Posts: 12
I am trying to establish a connection to an excel datasheet and read it in my eclipse project.
This is the exception that I am getting :
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

I am using 64 bit windows,jdk 6 x64,office 2007 and eclipse 64 bit.


Can anyone please tell me how to overcome this problem?
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Normally ODBC is used to connect to Databases.

For Excel you need to use Java APIs to extract their contents.

You may find a lot of libraries in the Internet.


S.D. MADHAN
Not many get the right opportunity !
Azeem Mohammed
Greenhorn

Joined: Jan 15, 2009
Posts: 12
I am using JDBC to to connect to the ODBC source using the bridge driver.Still,I am getting this error.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...
 
Similar Threads
Windows 7 Access DB Connection Error "Architecture Mismatch"
The specified DSN contains an architecture mismatch between the Driver and Application
error connect java with ms access
JDBC problems using Servlets
error involving 64-bit windows 7, can't figure it out