I am trying to use an MSAccess database for container authentication in
Tomcat 5.5.23. When I start Tomcat, I get this message in the
catalina.YYYY-MM-DD.log:

Aug 10, 2007 10:50:30 AM org.apache.catalina.realm.JDBCRealm start
SEVERE: Exception opening database connection
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
 at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
 at org.apache.catalina.realm.JDBCRealm.open (JDBCRealm.java:701)
 at org.apache.catalina.realm.JDBCRealm.start (JDBCRealm.java:769)
 at org.apache.catalina.core.ContainerBase.start (ContainerBase.java:1006)
 at org.apache.catalina.core.StandardEngine.start (StandardEngine.java:443)
 at org.apache.catalina.core.StandardService.start (StandardService.java:448)
 at org.apache.catalina.core.StandardServer.start (StandardServer.java:700)
 at org.apache.catalina.startup.Catalina.start (Catalina.java:552)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start (Bootstrap.java:295)
 at org.apache.catalina.startup.Bootstrap.main (Bootstrap.java:433)
Aug 10, 2007 10:50:30 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled


I setup my realm in server.xml as follows:

<Realm className="org.apache.catalina.realm.JDBCRealm"
 driverName="sun.jdbc.odbc.JdbcOdbcDriver"
 connectionURL="jdbc:odbc:Auth"
 userTable="User" userNameCol="UserName" userCredCol="Password"
 userRoleTable="User_Role" roleNameCol="RoleName" />

where Auth.mdb is the name of my MSAccess database. I configured Auth.mdb
in my ODBC Data Source Administrator, and I am able to access it and display
its tables from a Java application.

I am using Tomcat 5.5.23.

Has anyone used an MSAccess database via JDBC-ODBC for authentication in
Tomcat? Can anyone tell me what I am doing wrong?

--
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)