Need Help connecting to oracle...

[maheshu]

Hello,

Can somebody tell the steps to connect to oracle..Actually i tried to do this way..Start-settings- control pannel-ODBC-user DSN-add--after this i am not sure what i should do..some where i read that i should select "Microsoft ODBC driver for oracle" but i don't have that driver..how do i setup the driver ..& can u please let me know the remaining steps to connect to oracle..

Thank u..

[Memnoch1207]

Using ODBC

oConn.Open "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"

Using OLEDB

For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB; User Id=myUsername;Password=myPassword"
 
For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;User Id=/;Password="
' Or
oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB; OSAuthent=1"

[abhijit]

Also make sure that you Oracle NET Client installed on the machine from where you are trying to connect to Oracle.

Cheers!
Abhijit