This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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
It's not a secret anymore!