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