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;
Was this answer helpful? 0 Users Found This Useful (0 Votes)