Can you provide some more detail? When you say you're running two servers accessing an Access database, do you mean two different machines or just different server instances on the same machine?
If you're trying to access Access from a different machine, you may have to use a different jdbc driver. I don't think the Sun jdbc:odbc driver can reach a data source running on a different machine. Dave -----Original Message----- From: Aris Javier [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:55 AM To: Tomcat Users List Subject: Newbie Question Hello! This is a newbie question... =) I have two servers running accessing single MS Access database I used jdbc:odbc:CES_DS in server.xml CES_DS is the data source name I used for both servers... pointing to MS Access DB... However this error occurs... org.apache.commons.dbcp.DbcpException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. How to access a single database using two servers using DSN connection...? Please Help! Thanks a lot! aris --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
