| 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.
|
|
 |
|
|
subject: Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...
|
|
|
![The moose likes JDBC and the fly likes Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch...](http://cache-www.coderanch.com/mooseImages/moosefly.gif)
![Bookmark "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch..."](http://cache-www.coderanch.com/templates/default/images/bookmark_it.gif "You must login or register"){kind=small}
![Watch "Exception:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch..."](http://cache-www.coderanch.com/templates/default/images/watch_topic_start.gif "You must login or register"){kind=small}
0
