• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Dynamic DSN not working

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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(DAO.java:21)
at #my package redacted#.model.DocumentGateway.getNextDocumentId(DocumentGateway.java:14)
at #my package redacted#.model.DocumentManager.getNextDocumentId(DocumentManager.java:19)
at #my package redacted#.CompAnnotate.<init>(CompAnnotate.java:150)
at #my package redacted#e.CompAnnotate.main(CompAnnotate.java:59)



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
 
Willy Ray
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.

Thanks!

/willy
 
My first bit of advice is that if you are going to be a mime, you shouldn't talk. Even the tiny ad is nodding:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic