File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes microsoft access driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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)
I agree. Here's the link:
subject: microsoft access driver
jQuery in Action, 3rd edition