you did give it a DSN of some sort? Do you have the correct driver or MDAC update?
-----Original Message----- From: remmons [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 10:40 AM To: users@tomcat.apache.org Subject: Using MSAccess database for container authentication 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? -- View this message in context: http://www.nabble.com/Using-MSAccess-database-for-container-authentication-tf4249487.html#a12093749 Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]