Yes! two different machines... I will name it as machine 1 and machine 2...
machine 1 and machine 2 both have CES_DS datasource name declared.. MS Access DB resides inside machine 2... so machine 2 does not have any problems.. while machine 1 have problems connecting to MS Access DB inside machine 2... if Sun's jdbc:odbc:CES_DS connection is wrong for machine 1 then what connection will i use? Machine 1 have Exchange Server while Machine 2 have Sharepoint Server... just for info... Please Help Me!!! -----Original Message----- From: Dave Bender [mailto:[EMAIL PROTECTED] Sent: Fri 7/23/2004 9:11 PM To: Tomcat Users List Cc: Subject: RE: Newbie Question 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
