SQLException - Function sequence error

Receiving this SQLException when running. Onle gets exception when using new data files, files that have been tested before work corectly. The exact meesage is as follows:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error

at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLColAttributes(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getColAttribute(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getColumnType(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getMaxCharLen(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)

at DailyLoadBudget.loadPMStoBDG(DailyLoadBudget.java:613)

at DailyLoadBudget.main(DailyLoadBudget.java:1008)

SQL ERROR CODE = 0

SQL State CODE = S1010

Any ideas of where to start looking in the code to remoce exception? Have never received this exception before so I am having problems as to where I start to look to fix the problem.

[1111 byte] By [SingletonIII] at [2007-9-26 3:25:30]
# 1

look at

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)

You probably have a method resultset.getString(column info). Make sure that the resultset object is not null. Since it is ODBC, at the first instance of getXXX, load value into a variable. Do not do getXXX twice on the same column twice within a fetch. You will get the above error. I had the same problem when I used ODBC, instead of ORACLE. In Oracle I can do getXXX any number of times within a fetch with no problems.

dprasad_turaga at 2007-6-29 11:46:25 > top of Java-index,Java HotSpot Virtual Machine,Specifications...