permaculture playing cards*
The moose likes JDBC and the fly likes VAJava  EJB reading MS Access JDBC/ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "VAJava  EJB reading MS Access JDBC/ODBC" Watch "VAJava  EJB reading MS Access JDBC/ODBC" New topic
Author

VAJava EJB reading MS Access JDBC/ODBC

rhait
Greenhorn

Joined: Jul 13, 2001
Posts: 2
Hi,
I'm learning VAJava and new to Java in general. I'm using VAJ 3.5.3 on NT 4.0(SP6)and attempting to create and test an EJB that reads an MS Access database. My Access database was created using MS Office 2000. I have also tried to convert back to MS Access 97.
I have configured the ODBC source and tested the connection during the creation of the database schema.
All seems to be fine up to when I'm using the EJB test client. It loads fine and I'm able to enter my database key, but when invoking the request it terminates with:

"java.rmi.ServerException: RemoteException occurred in server thread; nested exception is: com.ibm.ejs.persistence.EJSPersistenceException: getPStmt failed; nested exception is: java.sql.SQLException: [Microsoft]{ODBC Microsoft Access Driver]Option feature not implemented"

From what I can make of it, I'm missing an ODBC driver, but I can't figure out where to get the uninstalled feature and most likely even when (or if) I do, how to install it.

Any help?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: VAJava EJB reading MS Access JDBC/ODBC
 
Similar Threads
VAJava EJB reading MS Access
JDBC problems using Servlets
Cpntainer Managed EJB - MS Access
Urgent !! why ? no suitable driver ???
Error trying to connect MS Acess 12 database