File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. " Watch "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. " New topic
Author

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

prashant komaragiri
Ranch Hand

Joined: Jan 23, 2001
Posts: 36
Hi,
I am trying to execute this query
SELECT Format(Appointments.AppointmentStartDateTime, "mm/dd/yyyy h") + ':00:00' As ModeDateTime From Appointments
after executing it gave the following error :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
My Back End is Access and iam using jdbc-odbc bridge.
Any solutions ?
Prashant


Sun Certified Programmer for Java 2 Platform
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
It seems like the DB does not support something. You may need to post some more code.


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

Joined: Jan 23, 2001
Posts: 36
Originally posted by Bosun Bello:
It seems like the DB does not support something. You may need to post some more code.

Hi Bosun
That is the Query which iam executing. The query is working fine in MS Access 2000 Sql Window.This query iam Executing through a jsp page Using tomcat.
Prashant
Craig Demyanovich
Ranch Hand

Joined: Sep 25, 2000
Posts: 173
The JDBC-ODBC bridge is not recommended for production use, as it's more like a reference implementation. Visit Sun's JDBC drivers page to find another driver that can work with Access.
Also, you may want to try the MSDN advanced search page for articles that address the "too few parameters" issue. It has always been a difficult one to track down for me, but I haven't developed against Access in many, many months.
Good luck,
Craig
[ May 28, 2002: Message edited by: Craig Demyanovich ]
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by prashant komaragiri:
Hi,
I am trying to execute this query
SELECT Format(Appointments.AppointmentStartDateTime, "mm/dd/yyyy h") + ':00:00' As ModeDateTime From Appointments
after executing it gave the following error :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
My Back End is Access and iam using jdbc-odbc bridge.
Any solutions ?
Prashant

Prashant: This error can occur if you mispelled the table or column names in your SQL statement. double check your spelling
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.