MySQL 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.

MySQL Connection Strings

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: dzone | digg | del.icio.us | stumbleupon

Comments