File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes DSN too long-  ODBC Error.  i've tried everything! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "DSN too long-  ODBC Error.  i Watch "DSN too long-  ODBC Error.  i New topic

DSN too long- ODBC Error. i've tried everything!

Brett Swift
Ranch Hand

Joined: May 22, 2002
Posts: 61
Using: VisualAge 2.0, Access2000.
I've double checked my DSN pointing to the right DB, and checked my code. My Select query works fine, but when I try to dynamically connect to the DB I get the error that my DSN name is too long. If I don't connect dynamically, then I get an error saying 'Optional Feature Not Implemented'.
I have the Jet 4.0 driver, haven't found any later releases.
I know Access isn't a great database, but its only going to be deployed on 1 computer.
If anyone has had this much trouble with this, please offer any solutions you have.
The code I am using is below. There is a lot of code commented out so you can see the code I am using for dynamic/non dynamic DB connections, as well as normal statements and PreparedStatements.
I hope someone out there can offer a helpful tip! Thanks!

[ August 03, 2002: Message edited by: Brett Swift ]
ps. how do you get rid of those smileys!!!??
[ August 03, 2002: Message edited by: Brett Swift ]

(Let's see if this is better -- Marilyn)
[ August 04, 2002: Message edited by: Marilyn de Queiroz ]
Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9059
At the bottom of the editing page, below the box where you type, below the smilies are some checkboxes. One is "Disable smilies in this post".

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Peter Reinhardt
Ranch Hand

Joined: Aug 02, 2002
Posts: 57
I think DSN less connection strings are not supported for MS Access.
Have a look at:
dsn less connection strings

SCJP 1.2, SCJD, SCEA, IBM 484, Weblogic 7
I agree. Here's the link:
subject: DSN too long- ODBC Error. i've tried everything!
It's not a secret anymore!