|
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:
How to create dsn less connection for connecting to s dbf file
Posted by Mags on August 15, 2001 at 12:59 AM
Hi, Thanks to your code. How to connect with dbf files dsn - less? please help mags > 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
Replies:
|