Hi John, >From the functional specs on http://industry.java.sun.com/products/jdbc/drivers, EasySoft's driver does not support DataSources!
>From Tomcat 4 documentation, it appears as you need to have a jar file (physical copy) of the driver placed in common/lib directory in order for Tomcat to set its classpath. Is this the case for built in generic drivers also, such as sun.jdbc.odbc. I'm getting the error ' Driver not found in the classpath.' when I try DataSource mechanism. Hassan ----- Original Message ----- From: "John Turner" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 9:48 PM Subject: [OFF-TOPIC] Re: JDBC and MS Access DB connectivity. > > MS Access = bad bridge driver = bad > > If you must use MS Access, you will need a bridge driver. The best you can > do is a Type 3 driver, like the one at easysoft.com. > > If that isn't an option, the Type 1 bridge driver is part of the Java 2 > SDK: package sun.jdbc.odbc. Check the SDK docs. > > John > > On Thu, 5 Jun 2003 21:26:32 +0100, Hassan <[EMAIL PROTECTED]> wrote: > > > I'm trying to use DataSource objects (eventually connection pooling) with > > MS > > Access Database. > > My question is, do we have to have an ODBC-JDBC Bridge driver in place in > > $CATALINA_HOME/common/lib/ location for using javax.sql.DataSource > > objects > > to create connections to the database. > > If so, where do I get this jar file for the driver? > > > > cheers > > Hassan > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ > > --------------------------------------------------------------------- > 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]