This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

DSN-Less Connection

Posted by P.Vimaladhithan on July 09, 2001 at 8:01 AM

Hai,

Hai two way to connect the DSN-Less connection in java.

First way:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/data/month.MDB";
DBConn = DriverManager.getConnection(myDB,"","");

Second Way:

Properties p=new Properties();
p.put("test","DRIVER={SQL Server};ServerName=itrackx;UID=defuser;PWD=password");
String sConnect =new String("jdbc:itrackx://192.233.0.3/,");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbCon = DriverManager.getConnection(sConnect,p);

Please reply to this modules are working or not.

with love & regards,
Vimaladhithan.P

• hi Mahesh Prasad October 04, 2001 at 3:49 AM (0)
• urgent amar October 03, 2001 at 5:26 AM (0)
• Working Frank Pippel August 08, 2001 at 2:03 PM (5)
  • How to create dsn less connection for connecting to s dbf file Mags August 15, 2001 at 12:59 AM (4)
    • Code is Not working Jaiwardhan August 28, 2001 at 9:22 AM (3)
      • Solution (I think). Miguel Mingo December 11, 2001 at 1:01 PM (0)
      • DsnLess Query Sridar Santhanam December 04, 2001 at 1:08 PM (1)
        • JDBC JDBC December 08, 2001 at 5:56 PM (0)