MSAccess and JDBC 1

[lestatdelioncourt]

Is there any way to connect to an MSAccess Database using JDBC without using an ODBC link?

I can do this for MSSQL using

com.microsoft.jdbc.sqlserver.SQLServerDriver()

But I can not find an MSAccess equvalent. The reason that I can not use ODBC is I am connecting from and AS/400.

 

[palbano]

>> Is there any way to connect to an MSAccess Database
>> using JDBC without using an ODBC link?

not unless you can find a JDBC driver for access that does not rely on ODBC. I have not done an exhastive search but my belief is that it does not exist.

does that help?

 

[lestatdelioncourt]

thanks I thought that was the case but was hoping there might have been a driver out there that I just could not find

 

[JVZ]

A company called aveConnect offers a JDBC driver that does not use ODBC....

aveConnect JDBC Driver for MS Access is a Type III (Net Protocol - Pure Java) JDBC Driver. Using a Pure Java JDBC driver instead of JDBC - ODBC Bridge and an ODBC driver eliminates the client configuration required by ODBC.

http://www.atinav.com/products/aveconnect/MSAccess.htm

There are more Driver...see list on Sun's site...

http://industry.java.sun.com/products/jdbc/drivers

Hope this help...

 

[palbano]

JVZ, not that i plan on using it but it's great information anyway, thanks.

-pete