Hi, I believe your access database cannot located on a remote machine because on security reason, even you map a permanent drive to the machine. Which mean it is not tomcat problem, even any asp, php will not work this way too. Check from Microsoft site. I read these article before.
Thanks ----- Original Message ----- From: "Schiza, Apostolia (ISS Atlanta)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 12:43 PM Subject: tomcat service not accessing DSNs > Hello, > I am working Win2k Server, and I have tomcat running as a service, from > LocalSystem Account. > I have created System Data Sources on windows to get to Databases residing > remotely (I have > actually created permanent mapped drives to those machines, so that I will > specify the DB path > in the DSN). > It seems like tomcat cannot access these DSNs, because I get the following > error: > 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. > > When Tomcat is running standalone (not as a service) then it can access the > DSN data just fine. > > I tried having the service running as an admin, but no luck. > > Any ideas?? > > Thank you! > > -Lia > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
