| 1. | Go to your control panel and click on ODBC
|
| 2. | Create the DSN. The DSN will be called "accountname-dsnname", with the account name being your control panel account name.
|
| 3. | In your ASP Script use this connection string: "DSN=accountname-dsnname"
|
|
|
|
|
| Using DSN-less Method:
|
|
|
| Use the following connect string to ADODB.Connection object:
|
| "Driver={MySQL ODBC 3.51 Driver}; Server=servername; Database=dbname; UID=username; PWD=password"
|
|
|
| Where servername is as indicated on your control panel.
|