This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
cannot connect to microsoft access with jsp
how to access data in excel
no dafault driver specified
error when i run the program
Code error