The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
November 2000

Advertisement

Advertisement

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



Replies:

Sponsored Links



Google
  Web Artima.com   
Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us