Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Azeem Mohammed
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 312
Java MS IE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Azeem Mohammed
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using JDBC to to connect to the ODBC source using the bridge driver.Still,I am getting this error.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic