This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes ODBC - too few parameters ?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ODBC - too few parameters ??" Watch "ODBC - too few parameters ??" New topic
Author

ODBC - too few parameters ??

Julie de Wet
Greenhorn

Joined: Apr 04, 2004
Posts: 17
This is probably a trivial problem - but I'm stuck
SELECT MA-nr, Fornavn FROM Medarbejder WHERE MA-nr = '0200695';
I make a PreparedStatement with the above sql, when I call executeQuery I get the following exception:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access-driver] Der er for f� parametre. Der var ventet 2
i.e. too few parameters - 2 were expected.
What could be possible/probable causes ?
Julie de Wet
Greenhorn

Joined: Apr 04, 2004
Posts: 17
It was trivial. It was the hyphon.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ODBC - too few parameters ??
 
Similar Threads
JDBC-ODBC with Access : Error in Execution
Excel file manipulation
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Why it is not INSERTing
Download SCEA Exam1 Practice Program