posted 19 years ago
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 ]