Hi,
It sounds like some incompatibility of SQL in MS Access. You might have to
rewrite a few SQL statements in your servlet. Try to somehow extract the
query string as it is executed via ODBC and execute it directly in MS
Access. It should tell you what's wrong with the query.
Petr
----------
From: Horvath Zsolt [SMTP:[EMAIL PROTECTED]]
Sent: Monday, 08 March, 1999 9:35 AM
To: [EMAIL PROTECTED]
Subject: more Access...
Hi!
I have to use the Access odbc-driver (via jdbc-odbc bridge on
NT), but
it doesn't work properly.
Previously I've used the same servlet to access some database
(MSSQL,
Oracle Rdb), i only had to change the ODBC DSN-name and it worked
fine...
After that i've transfered this DB to MS Access mdb, i've
replaced the
DSN name and tried it ..... it's thrown me an error message:
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few
parameters.
Expected 1.
> Vendor: -3010
This message was occured when the
PreparedStatement.executeQuery()
method was carried out....
What should I do differently ?
One more time: the same servlet (with DSN name excepted)
previously
worked without troubles....
Thanks for any help,
Zsolt.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
of the message "signoff SERVLET-INTEREST".
Archives:
http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
