RSS

Tag Archive | "Oracle"

Oracle connection strings

Tuesday, August 12, 2008

0 Comments

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

Continue reading...