File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "microsoft access driver " Watch "microsoft access driver " New topic
Author

microsoft access driver

gsk
Greenhorn

Joined: Jan 25, 2002
Posts: 3
hi,
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
Rancher

Joined: Mar 06, 2001
Posts: 13459

"gsk",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
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.
Thanks.
Dave
David O'Meara
Rancher

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 ResultSet.next() 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)
Dave.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: microsoft access driver
 
Similar Threads
Hibernate query
Error in insert into
Database
creating virtual tables
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect