Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Brett Swift
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9065
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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".
 
Peter Reinhardt
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think DSN less connection strings are not supported for MS Access.
Have a look at:
dsn less connection strings
Peter.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic