aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
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.
 
jQuery in Action, 2nd edition
 
subject: Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...