Connect to the MySQL database in ASP and use MyODBC

We all know that the two most widely used methods for connecting ASP and MySQL are: first, using components and often using MySQL (the best combination with PHP) X, unfortunately, the price is very expensive. The other is to use MyODBC to connect to the MySQL database. Let's take a look at the second method.

Test Platform:

MySQL (the best combination with PHP) 4.0 For RadHat Linux can also be used for windows)

Windows 2003 standard Edition Windows XP English

1. Install MyODBC

1. Visit the website www. MySQL (the best combination with PHP). com and download MyODBC. We use version 3.51.

2. Install MyODBC in Windows

The file name of the downloaded mydbc-3.51.06.exe varies by version)

2. Establish an ODBC connection to the MySQL database

Go to Control Panel> ODBC Data Source

At this time, we can see that there is already one in the user DSN: myodbc3-test, pay attention to the Driver on the right {MySQL (the best combination with PHP) odbc 3.51 driver} This parameter will be used as a Conection String connecting ASP to the database without missing a word ).

Add a "system DSN"

Select "system DSN" in the dialog box, and click "add" on the right. This will allow you to select a data source. Select MySQL (the best combination with PHP) ODBC 3.51 Driver. Press "end ". The above content is an introduction to connecting to the MySQL database in ASP. I hope you will have some gains.