This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
selman Fermitsjelli
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic