MySQL Connection Strings

Search

or browse popular tags

Got questions?

We got answers.

Ask your question about PHP, ASP, Javascript, HTML, CSS, hosting and get professional help, free of charge.

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

Need help with ASP, PHP, Javascript?

Let our experts help you.

Web hosting (PHP,ASP,MySQL,SQL server,unlimited emails)

Tags: MYSQL ODBC OLEDB CONNECTION STRINGS DATABASE

Add To: dzone | digg | del.icio.us | stumbleupon

Comments