Well, I also had the same problem earlier for my Java project when I tried porting it to Linux.
The best(??) and the simplest soln could be to get your hands on Sun JDK 1.2 onwards - in case if you wanna use JDBC.
As far as JDBC-ODBC Bridge drivers are concerned, all the drivers available with any SQL server for Linux (includind MySQL & PostgreSQL) are very poorly written. And this is where the major problem lies. So even if you configure your ODBC DSN properly, your java program won't connect to the DB.
After you have a very well written JDBC-ODBC Bridge, you can configure your ODBC DSN to use any database - be it on MSSQL or Linux.
You don't need to change your Class.forName() statement in any case - unless you're using some other driver and not coded it here. Class.forName() will just instanciate the class specified as a "String classname" parameter to it. ------------------
I'll tear thee open make you gone No longer will you hurt anyone And the hate still shapes me So hold me until it sleeps
Metallica - Until It Sleeps
----- Original Message ----- From: "Pankaj Jangid" pankaj_jangid@yahoo.com To: "Linux Users Mumbai" linuxers@mm.ilug-bom.org.in Sent: Thursday, February 21, 2002 8:00 PM Subject: [ILUG-BOM] ODBC DSN Configuration
_________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com