Randomly I get java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error.
It comes and goes as I run a query on a MSAccess database with about 3500 records in the database. Sometimes it will make it to record 1400 and sometimes to 3000 and sometimes it will have no problem with all 3500 records. I am using JDK 1.2.2 and using sun.jdbc.odbc.JdbcOdbcDriver as our connection driver.
This error makes no sense to me. There is only one database connection open and only one recordset open and it is crapping out in the middle of the open recordset. I've read that you can get this error if 2 recordsets are open simutaneously, but I'm not having that problem. Please if anyone can help, I need some fix ASAP. Is it a bug with the version of the JDK or something?