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

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