Ms Access JDBC Driver?

[metaltecks]

I have a Java product; Lawson, that is trying to connect to MS Access
database on a network share.
It is asking for the JDBC driver for it and i thought it was
jdbcdbc:JdbcOdbcDriver, but it keeps on telling me that the connection is
failing.

Can someone help me.

Thank you

 

[Arvin Meyer [MVP]]

There is no JDBC driver that comes with Access (at least that I'm aware of)
You'd have to get the driver from your language supplier.

 

[Guest]

It could be that the connection is failing... Access/Jet/MDB
is very sensitive to network connections. Any network
problem is likely to cause an Access/Jet/MDB problem.

Also, what kind of system is hosting the network share?
Do you have full c/r/u/d permissions?

Also, can you test the ODBC connection outside of
the JDBC connection? Using something like Excel?

(david)

 

[a a r o n . k e m p f]

whatever dude.

any time that your database chipmunks blame things on the network--
THAT is when you know you're supposed to move to SQL Server

Stop blaming things on the network.
Access is just a flakey ****ing database and anyone using it for
professional apps should be fired and then spit upon

Move to SQL Server. Use ADP. Things just work there.

 

[metaltecks]

I have tested it out on the odbc administrator and do have full permissions
to the share. The share is on a windows 2003 server.

 

[Guest]

If you've got any other kind of ODBC source, have you
tried connecting to that, to see if you have a JDBC installation
or configuration problem?

Apart from that I'm out. Every ODBC connection problem
I've ever seen with Access could be diagnosed and fixed
from the ODBC administrator on the machine where the
client is installed. If the Access connection connects there,
anything can connect to it. The actual connection API is simple
and standard, and nobody ever gets it wrong, so the chance
that there is some internal bug with jdbcdbc:JdbcOdbcDriver
and the Access driver is zero.

(david)