Is there some thing I am missing or Access driver donot support Prepared statements ? I have experimented different drivers but this is what I get for prepare statements .
Please reply ....... this is mind bogling !
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterFloat(JdbcOdbc.java:857)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setLong(JdbcOdbcPreparedStatement.java:580)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1139)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1078)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement.java:1069)
at com.adspedia.util.test.AccessMethods.select(AccessMethods.java:131)
at com.adspedia.util.test.AccessMethods.main(AccessMethods.java:55)
Exception in
thread "main"
[ June 14, 2002: Message edited by: Laksh Anan ]
[ June 14, 2002: Message edited by: Laksh Anan ]