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 ]