MySQL connection string in Classic ASP

Classic ASP Comments Off on MySQL connection string in Classic ASP

The mysql connection string in classic ASP.

strconnect = "Driver={MySQL ODBC 5.1 Driver};Server=SERVERADDRESS;uid=USERID;pwd=PASSWORD;database=DATABASENAME;"

In the above snippet strconnect is a variable where we are assigning connection string values.

The driver can be different, you may have to change it to{MySQL ODBC 3.51 Driver} if you are using ODBC 3.51 for mysql.

SERVER ADDRESS is your mysql server address in your hosting your environment. Change it to localhost if the mysql server is in your local system.

USERID is your username of the mysql server, PASSWORD is password of the mysql server.

DATABASENAME is the name of the database in the mysql server.



Author

Search

Back to Top