-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Daniel,
Daniel Stephens wrote:
> Also, make sure that whatever "jar" file has this
> sun.jdbc.odbc.JdbcOdbcDriver class, is located in your tomcat
> common/lib.
This is a standard class that comes with the Sun JRE. There is no need
for any additional JAR files.
> As well as having a binding in your context.xml or web.xml like
> below. And have the datasource configured in the server.xml or
> equivalent(I think 5.5 sets up the Datasources a little different).
> but you'll need the following configured.
The OP is using a JDBC realm, not configuring a DataSource. Don't
complicate things, here.
I would advise the OP to check online for how to connect Java to Access
in general before adding Tomcat into the mix. Using MS Access requires
you to setup an ODBC DataSource in Windows. Have you done that? Is it
called "Auth"? The connection URL was "jdbc:odbc:Auth", so it should be.
I've never used Access with Java (or by itself, for that matter), but
I've seen connection URLs like this, too:
"jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);
DBQ=D:\\path_to_db\db.mdb;PWD=mypass"
This appears to define it's own data source instead of requiring you to
create one in the control panel.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGvJzU9CaO5/Lv0PARAgg1AJ90pWZ/jhYheC/bCL/uG+bHZAxPNACdF4Xb
PQqTPRSwxn24giPvVRwlzxQ=
=We8r
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
