Hi, Thanks for your reply, Is there a jar file that I need to include if I wish to use the JDBC/ODBC bridge supplied by the JVM? Because, I did not do that. Yet, the datasource gets detected and DB properly updated when I do not run Tomcat as a service. But when I try to run it as a WINNT service, I get an error saying unable to find datasource and driver.
Thanks for any help. Runu First of all, there is no "JDBC Driver For MSAccess" that I'm aware of. You'll need the ODBC driver plus an ODBC/JDBC bridge. Sun ships one with the VM, but I recommend the Easysoft JDBC/ODBC bridge (more robust and flexible). Place the EasySoft EJOB.JAR file in your webapp's lib directory. You'll also need to make certain that you set up a *SYSTEM* ODBC data source pointing to your Access database, and use this to define the JDBC connection URI. Rick Bullotta CTO Lighthammer Software (http://www.lighthammer.com) __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
