Showing posts with label Oracle Connection String. Show all posts
Showing posts with label Oracle Connection String. Show all posts

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;"