aspose file tools*
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
JavaRanch » Java Forums » Java » Java in General
Bookmark "DSN too long-  ODBC Error.  i Watch "DSN too long-  ODBC Error.  i New topic
Author

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
Sheriff

Joined: Jul 22, 2000
Posts: 9044
    
  10
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".


JavaBeginnersFaq
"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
Peter.


SCJP 1.2, SCJD, SCEA, IBM 484, Weblogic 7
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DSN too long- ODBC Error. i've tried everything!