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