Only 44 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
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
Boost this thread!