Home page   WebCheatSheet.com


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


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