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:

Working

Posted by Frank Pippel on August 08, 2001 at 2:03 PM

They first one works!!! I needed to get it working so thanks.

I am not sure if the second on does. Actually I am not sure what the second on eis doing so I am not gonna try it.

> 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

• 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)