aspose file tools*
The moose likes JDBC and the fly likes JDBC - MSACCESS - PREPARED STATEMENTS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC - MSACCESS - PREPARED STATEMENTS " Watch "JDBC - MSACCESS - PREPARED STATEMENTS " New topic
Author

JDBC - MSACCESS - PREPARED STATEMENTS

Lakshmi Anantharaman
Ranch Hand

Joined: Aug 01, 2001
Posts: 58
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
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
There must be something else wrong. I have used prepared statements to access MS Access using the JDBCODBC bridge.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC - MSACCESS - PREPARED STATEMENTS