Re: Newbie question about jdbc:odbc connection

2004-12-03 Thread Ananthalakshmi Subramaniyam
Hi, You will have to load JDBC-ODBC bridge driver, with the following statement, Class.forName("jdbc.odbc.JdbcOdbcDriver"); //loads the driver before calling DriverManager.getConnection. Thanks, H.Ananthalakshmi. From: Thomas Tsang <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Page

Re: Newbie question about jdbc:odbc connection

2004-12-03 Thread Thomas Tsang
Thank for your information. However, the following error is display after the line Class.forName ("jdbc.odbc.JdbcOdbcDriver"); is add before the line connBooking = ... = javax.servlet.ServletException: jdbc.odbc.JdbcOdbcDriver org.apache.jasper.runtime.PageContextImpl.doHandlePageExce

Re: Newbie question about jdbc:odbc connection

2004-12-03 Thread Darshan Kashi
Hi , It should be Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Regards Darshan On Fri, 3 Dec 2004 03:11:08 -0700, Thomas Tsang <[EMAIL PROTECTED]> wrote: >Thank for your information. > >However, the following error is display after the line Class.forName >("jdbc.odbc.JdbcOdbcDriver"); is ad

Re: Newbie question about jdbc:odbc connection

2004-12-03 Thread Martin Gainty
To quote a fellow from the J2EE List Using MS Access with CMP enterprise beans is like putting a moped engine in a Mercedes-Benz. At one time I worked for a company that was using the Jdbc-Odbc bridge for connecting to SQL Server DB. This was fine for 20 records. We experienced serious performance