• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

executeUpdate ODBC Too few parameters

 
Brett Swift
Ranch Hand
Posts: 61
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have checked the SQL string, and it is valid, so its got to be part of the Java code.
I am using an Access2000 Database. And popped up a JOptionPane that gave the message:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
sometimes says Expected 2.
I am confused as to what the problem is here? I have done some searches and I have found that it is usually a mis-spelled column name (ie Make would not be in the DB). however I have used the same SQL statement and put it right into Access and it worked fine!
I am using VisualAge 2.0, so i stepped through and took the exact sql from the debugger... I know the SQL is fine!
 
Dan Cranmer
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You might want to check the parameters you pass to the getConnection method. The following is what we use for Oracle.

There should be some examples of how to use the MS database and jdbc.
[ August 02, 2002: Message edited by: Dan Cranmer ]
 
Brett Swift
Ranch Hand
Posts: 61
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have searched and my code seems to be fine, so it must be either a driver error, or something else.... I have tried PreparedStatements too, and that just gives other errors... check my other post
 
Cindy Glass
"The Hood"
Sheriff
Posts: 8521
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to the JDBC forum.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic