types of drivers

[venkat]

please send the connection code for all 4 drivers.

[David O'Meara]

Connection code is always the same regardless of Driver version, vendor and type, that's the point.

Please see the warning on your display name here, your account is about to be deleted.

[ganesh narayana]

Dear Friend,

only the driver and URL differes from one type to second type.

type1

driver : sun.jdbc.odbc.JdbcOdbcDriver
url : jdbc dbc:<<dsn name>>

type 2 for oracle

driver : oracle.jdbc.driver.OracleDriver
url : jdbc racle ci8:@

type 4 for oracle

driver : oracle.jdbc.driver.OracleDriver
url : jdbc racle:thin:@localhost:1521:<<oracle SID>>


then use Class.forName(driver name)
Connection con=DriverManager.getConnection(url,username,password)

for example :

Class.forName(oracle.jdbc.driver.OracleDriver)
Connection con=DriverManager.getConnection("jdbc racle:thin:@localhost:1521:<<oracle SID>>","scott","tiger");




to connect to the specific database.