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

MySQL Connection Strings

Print

ODBC connection strings

 Local MySQL database using MySQL ODBC 3.51 Driver:

<%
'declare the variable that will hold the connection string
Dim ConnectionString 
'define connection string, specify database driver and location of the database
ConnectionString= "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost;" &_
"DATABASE=your_mysql_database; UID=your_username; PASSWORD=your_password; OPTION=3"
%>

 Remote MySQL database using MySQL ODBC 3.51 Driver:

<%
'declare the variable that will hold the connection string
Dim ConnectionString 
'define connection string, specify database driver and location of the database
ConnectionString="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306;" &_
"DATABASE=your_mysql_database; USER=your_username; PASSWORD=your_password; OPTION=3;"
%>

OLE DB and OleDbConnection (.NET framework) Connection Strings

 Standard:

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



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.