Oracle Database Connection Strings
The Oracle Database (commonly referred to as Oracle RDBMS or
simply Oracle) consists of a relational database management
system (RDBMS) produced and marketed by Oracle Corporation.
Oracle database conventions refer to defined groups of ownership
(generally associated with a "username") as schemas.
Most Oracle database installations traditionally come with a
default schema called SCOTT. After the installation process has
set up the sample tables, the user can log into the database
with the username scott and the password tiger. The name of the
SCOTT schema originated with Bruce Scott, one of the first
employees at Oracle (then Software Development Laboratories),
who had a cat named Tiger.
The SCOTT schema has seen less use as it uses few of the
features of the more recent releases of Oracle. Most recent
examples supplied by Oracle Corporation reference the default HR
or OE schemas.
Other default schemas include:
- SYS (essential core database structures and utilities)
- SYSTEM (additional core database structures and utilities, and privileged account)
- OUTLN (utilized to store metadata for stored outlines for stable query-optimizer execution plans.
- BI, IX, HR, OE, PM, and SH (expanded sample schemas containing more data and structures than the older SCOTT schema).
Variable Legend
| Variable Name | Substitute variable with: |
|---|---|
| Server | Replace with your server host address. |
| DBName | Replace with your database name |
| User | Replace with your database's username |
| Password | Replace with your database's password |
Oracle ODBC connection strings
Open connection to Oracle database using ODBC
"Driver= {Microsoft ODBCforOracle};Server=Server.world;Uid=User;Pwd=Password;"
Oracle OLE DB & OleDbConnection (.NET framework) connection strings
Open connection to Oracle database with standard security:
- "Provider=MSDAORA;Data Source= DBName;UserId=User;Password=Password;"
- "Provider= OraOLEDB.Oracle;DBName;UserId=User;Password=Password;"
Oracle OLE DB & OleDbConnection (.NET framework) connection strings
Open trusted connection to Oracle database
"Provider= OraOLEDB.Oracle;DataSource=DBName;OSAuthent=1;"