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 microsoft access driver 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 "microsoft access driver " Watch "microsoft access driver " New topic

microsoft access driver


Joined: Jan 25, 2002
Posts: 3
i get an error saying
"""[odbc Microsoft Access Driver] optional parameter not implemented"""
so, if anyone know the soln can give a reply.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please re-register and select a new name which meets the requirements.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Sorry about that, I like getting the book-keeping out of the way first.
When you use a driver, you rely on it to implement the entire JDBC API. The problem is, quite often they don't. Sounds like you are trying to use a method that should exist (according to the API) but hasn't been written in your driver.
If you are using the jdbc-odbc bridge it gets much worse, since I'm pretty sure this only implements a small part of the JDBC 2.0 API.
Your options are to either live without the extra functionality (ie use and close() only) or use the specific Type 4 Driver for your database (unless you're using Access, in which case you should use something else)
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: microsoft access driver
Similar Threads
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
Hibernate query
creating virtual tables
Error in insert into