ODBC Connection String for MySQL

In an environment where the IIS worker process runs as 32-bit, use one of the following:

Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
 
Driver={MySQL ODBC 5.2 UNICODE Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
 
In an environment where the IIS worker process runs as 64-bit, use one of the following:
 
Provider=MSDASQL;Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
 
Provider=MSDASQL;Driver={MySQL ODBC 5.2 UNICODE Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
  • ODBC, MySQL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Redirect non-SSL to SSL in Linux (Apache)

Create a file .htaccess in the document root of your site with the following code.  If this file...

Redirect non-SSL to SSL in Windows (IIS)

The following code sample will 301-redirect http://www.domainname.com to...

How do I redirect my site using a .htaccess file?

Note: Applies to Linux hosting accounts only. Create an empty text file using a text editor such...

Enable custom error pages on IIS 7 (Windows 2008) and newer

Custom error pages can be implemented in IIS 7 (Windows 2008) and newer by placing a web.config...

Remotely view error messages on IIS 7 (Windows 2008) and newer

When a website page encounters a coding error on a IIS 7 (Windows 2008) or newer hosting server,...