aspose file tools*
The moose likes JDBC 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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified