JDBC - MSACCESS - PREPARED STATEMENTS

[Lakshmi Anantharaman]

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 ]

[Bosun Bello]

There must be something else wrong. I have used prepared statements to access MS Access using the JDBCODBC bridge.

[Jamie Robertson]

Originally posted by Bosun Bello:
There must be something else wrong. I have used prepared statements to access MS Access using the JDBCODBC bridge.

Lakash:
you must have an older version of the MSAccess ODBC driver than most people. Most of the newer versions support this feature. Try downloading a newer version of your MSAccess ODBC driver from Microsoft to see if that solves your problem
Jamie