Connecting to MySQL through ASP(IIS)
Submitted by rayboy on May 23, 2007 – 2:32 pm2 Comments
You will need to download the MySQL ODBC driver and have it installed on the IIS first.
set cnn = Server.CreateObject(”ADODB.Connection”)
cnn.open = “DRIVER={MySQL ODBC 3.51 Driver};”_
& “SERVER=11.11.11.11;Port=3306;Option=4;”_
& “DATABASE=database_name;”_
& “UID=databaseuser;PWD=password;”
Ensure port 3306 , is open in the firewalls between the db server and IIS (its localhost if it is MySQL is installed on the same server. Not many people know that we can use MySQL for our ASP applications. MySQL is extremely strong and powerful as on the same levels as MS SQL . but those who need clustering and redundancy , then MySQL Entreprise Edition is the RDBMS which is needed.
(No Ratings Yet)
Loading ...
Loading ...
[...] Connecting to MySQL through ASP(IIS) at Rayboy (tags: asp_mysql) [...]
Hi all!
Looks good! Very useful, good stuff. Good resources here. Thanks much!
G’night