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 Error: [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 "Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. " Watch "Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. " New topic
Author

Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

Vishnu Munnangi
Ranch Hand

Joined: Sep 28, 2004
Posts: 114
Hi I am executing the following Program.



The Tabel Name, Column name all are correct. But I am getting the following error message

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

Any help would be appreciated.

Thanks!

[edited to add code tags and disable smilies]
[ November 26, 2004: Message edited by: Jeanne Boyarsky ]
Gaurav Chikara
Ranch Hand

Joined: Jun 09, 2000
Posts: 410
You are not giving user id and password for the dsn you created for ODBC driver
and using DriverManager.getConnection is not at all recommeneded as it syncrhronizes access to class and you only have one thread of connection
Better avoid it


SCJP,SCWCD,SCBCD<br />If Opportunity doesn't knock then build the door
 
GeeCON Prague 2014
 
subject: Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.