Home page   WebCheatSheet.com


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


Copyright © 2005-2007 www.WebCheatSheet.com All Rights Reserved.