Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
ASP Tutorial
Subscription

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

Privacy Policy

RSS Twitter

Oracle Connection Strings

Print

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: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





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