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