This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Watch "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" New topic
Author

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

selman Fermitsjelli
Greenhorn

Joined: May 04, 2011
Posts: 5
I would like you guys to help me out with this one.

I am using a 32bit version of Easyeclipse (the only one) and a 32bit driver of microsoft access driver... BUT a 64bit of windows 7
I get the subject error message when I run my java application.

App code:


The full error message:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DbTestAccess.main(DbTestAccess.java:20)

I am sure the path to the database is correct and the driver is also correctly configured.
Any help would be appreciated.

edit: some collegue students had the same problem, but they solved it by using the same method I applied (creating the driver in 32 bit odbcad32.exe)
 
jQuery in Action, 3rd edition
 
subject: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 
It's not a secret anymore!