didn't imply there was a need for additional jars. Just trying to make clear he needed the one the one with that class. . Also didn't mean to complicate it, just trying to help figure out where the issue was going.
On 8/10/07, Christopher Schultz <[EMAIL PROTECTED]> wrote: > > -----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] > >
