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!
Joined: May 24, 2000
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 ]
Joined: May 22, 2002
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
Joined: Sep 29, 2000
Moving this to the JDBC forum.
"JavaRanch, where the deer and the Certified play" - David O'Meara