Oracle Connection Strings

Search

or browse popular tags

ASP Tutorial

ASP Objects

Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Oracle Connection Strings

ODBC connection strings

<%
'declare the variable that will hold the connection string
Dim ConnectionString
'define connection string, specify database driver and location of the database
ConnectionString="Provider=MSDAORA;Data Source= your_oracle_database;" &_
"UserId=your_username;Password=your_password;"
%>

This one's from Microsoft, the following are from Oracle:

<%
'declare the variable that will hold the connection string
Dim ConnectionString
'define connection string, specify database driver and location of the database
ConnectionString="Provider=OraOLEDB.Oracle;your_oracle_database;"
"UserId=your_username;Password=your_password;"
%>

OLE DB and OleDbConnection (.NET framework) Connection Strings

<%
'declare the variable that will hold the connection string
Dim ConnectionString
'define connection string, specify database driver and location of the database
ConnectionString= "Provider= OraOLEDB.Oracle;DataSource=your_oracle_database;OSAuthent=1;"
%>

Tags:

Add To: dzone | digg | del.icio.us | stumbleupon

Comments