Tuesday, May 20, 2008

connection string for Oracle database in .net

Oracle ODBC connection strings


Open connection to Oracle database using ODBC
"Driver= {Microsoft
ODBCforOracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;"

Oracle OLE DB & OleDbConnection (.NET framework) connection strings
Open connection to Oracle database with standard security:

1. "Provider=MSDAORA;Data Source=
Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;"
2. "Provider=
OraOLEDB.Oracle;Your_Oracle_Database;UserId=Your_Username;Password=Your_Password;"

Open trusted connection to Oracle database
"Provider=
OraOLEDB.Oracle;DataSource=Your_Oracle_Database;OSAuthent=1;"

No comments: