954,518 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Oracle Connection

Hello,

Please send me the equivalent code for the following
i.e the Database connecting code is written for MS Acess

I want to know for Oracle.


Class.forName("jdbc:odbc:dsnName");

Connection con=DriverManager.getConnection("jdbc.odbc.JdbcOdbcDriver","","");


can we use the same code(The above given) to connect to SQL Server.

With warm regards,
Azmat

Azmat
Newbie Poster
1 post since Sep 2004
Reputation Points: 10
Solved Threads: 0
 

Hello,

Please send me the equivalent code for the following i.e the Database connecting code is written for MS Acess

I want to know for Oracle.

Class.forName("jdbc:odbc:dsnName");

Connection con=DriverManager.getConnection("jdbc.odbc.JdbcOdbcDriver","","");

can we use the same code(The above given) to connect to SQL Server.

With warm regards, Azmat


u can either give the dsn name as in case of sql server or can give the ip address + port no of ur db server and then try to connect

tigerxx
Light Poster
35 posts since Sep 2004
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You