SQL STRINGS

Oracle Connection Strings

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

• SQL Strings
• SQL Server Connection Strings
• MS Access Connection Strings
• MySQL Connection Strings
• Oracle Connection Strings
• Database Glossary
• MySQL PHP Connection
• MySQL Perl Connection
• MS Access ASP Connection
• MS SQL Server ASP Connection
• MySQL ASP.NET Connection
• MySQL ASP Connection