hello, i think, i have a smal problem, but i can't see the solution. i created a connection to access97, i can read the datas in the tables, but the connection doesn't close.
in line connection.close(); access is sending an error: "[Microsoft][ODBC Microsoft Access 97 -Treiber]Ung�ltiger Transaktions-Zustand." (invalid transaction condition) have i forgotten something? regards, janine [ Edited by Dave to format code and remove smilies ] [ January 08, 2003: Message edited by: David O'Meara ]
Hello, just a suggestion, you set Autocommit to false, maybe you inserted something and forgot to commit? Try to remove the setAutocommit(false) since it seems that you are only reading data, or try to commit I hope it helps
By constantly trying one ends up succeeding. Thus: the more one fails the more one has a chance to succeed.
"Janine", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp. We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements. Thanks. Dave
posted 17 years ago
Thanks, it was the autocommit
He loves you so much! And I'm baking the cake! I'm going to put this tiny ad in the cake: