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:

urgent

Posted by amar on October 03, 2001 at 5:26 AM

its alright with the ms access. but i want to know with the oracle database...
please reply
with regard
amar
-----
> 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