File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Dynamic DSN not working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Dynamic DSN not working" Watch "Dynamic DSN not working" New topic

Dynamic DSN not working

Willy Ray

Joined: May 04, 2008
Posts: 11
Hey all, I tried the instructions listed here: Dynamic DSN instructions

They're not working for me for some reason.

It works if I getConnection(url), using the system DSN "notes", but if I try to do it on getConnection(DB_URL_PREFIX), I get this:

java.sql.SQLException: General error
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 #my package redacted#.model.DAO.getConnection(
at #my package redacted#.model.DocumentGateway.getNextDocumentId(
at #my package redacted#.model.DocumentManager.getNextDocumentId(
at #my package redacted#.CompAnnotate.<init>(
at #my package redacted#e.CompAnnotate.main(

I've tried every possible variant of the path separator, including, \, \\, /, and File.pathSeparator. I've tried it with and without the ";DriverID=22;READONLY=false";" suffix. Always the same error.

Any ideas?

Willy Ray

Joined: May 04, 2008
Posts: 11
Did you ever notice how talking about a problem to a different group of people sometimes makes you see it in a different way? After I posted this (just now), I got thinking about the NAME of the driver. So, I poked around in my system settings, and found that all my static DSNs that pointed to Access files referenced the name of the driver as:

MicroSoft Access Driver (*.mdb)

I looked again at my code, copied in part from the instructions, and found that it indicated:

{MicroSoft} Access Driver (*.mdb)

Slight difference, those curly braces. Could that be the problem?

Turns out it is. I'm now Dynamic DSN-enabled.

I'd suggest updating those instructions to indicate possible differences in name of driver for .mdb.


I agree. Here's the link:
subject: Dynamic DSN not working
It's not a secret anymore!