Java + MSAccess + access function

Thread view:

Belgarath - 04 Apr 2007 15:45 GMT

Hello,

I need to make queries on Ms Access database (which is on a server)
from a java applet (which is on the same server).

The connection works and i can make some queries without problem :)

BUT some of these queries are made thanks to Access functions in VBA
and when i execute them an exception is thrown ... :

java.sql.SQLException: [Microsoft][Pilote ODBC Microsoft Access]
Fonction 'TempsOuvre' non définie dans l'expression.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:
338)
at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:
253)

How can I execute these queries ? Is there any way to load these
functions ?

Thank you all

.

Reply to this Message

Arne Vajhøj - 05 Apr 2007 01:50 GMT

> I need to make queries on Ms Access database (which is on a server)
> from a java applet (which is on the same server).
[quoted text clipped - 17 lines]
> How can I execute these queries ? Is there any way to load these
> functions ?

You can not use VBA functions when accessing a Jet database via
ODBC.

You will need to move functionality from the database to
the application.

Arne

PS: The JDBC-ODBC bridge is not suited for production usage.

Reply to this Message

Java + MSAccess + access function

Free Magazines