Well, As far as I know, once you initialize your driver with Class.forName(), you use DriverManager.getConnection() to establish/activate the connection with the DB, passing the URL of the DB as a string to getConnection(). In that case, you don't need to change any other statements as this is a generic way of establishing connections.
What the documentation says is : "When the method getConnection is called, the DriverManager will attempt to locate a suitable driver from amongst those loaded at initialization and those loaded explicitly using the same classloader as the current applet or application. "
There are two more ways of connecting to the DB given in the documentation of DriverManager class. Check them out for more details.
But still, the JDBC-ODBC Bridge provides much more flexibility (at a price, though), hence, I prefer the Bridge drivers.
Kunal
PS : One sincere request : Pls. don't send mails as attachments, rather send them as inline text. ------------------
My eyes seek reality My fingers seek my veins Theres a dog at your back step He must come in from the rain I fall cause I let go The net below has rott away So my eyes seek reality And my fingers seek my veins
Metallica - Low Man's Lyric
----- Original Message ----- From: "Pankaj Jangid" pankaj_jangid@yahoo.com To: linuxers@mm.ilug-bom.org.in Sent: Saturday, February 23, 2002 9:57 AM Subject: Re: [ILUG-BOM] ODBC DSN Configuration
_________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com