Using
MySql Database Server in ASP is pretty simple, but it's hard to
come accross a straight forward tutorial on ASP & MySQL. So
if you need to setup MySQL to run with ASP this is the tutorial
for you.
This
tutorial received 23 excellent ratings from 23 people
on planetsourcecode.com
the largest public source and tutorial database
on the internet.
The
latest versions are listed on the left side of the page almost
dead center under Database Server.
MySQL
Page 2
On
the next page you will find different Operating
Systems:
You
can either choose one of the following:
Download
now > immediate download
Choose
a mirror closest to you
Next
is an optional survey or continue to the bottom
to choose a mirror
Then
find the mirror closes to you and start the download!
Now
download MyODBC which is the driver to connect
to mysql from within ASP.
From
the front page of mysql.com under Connector/ODBC
Click
on the driver next to "Production:",
meaning it can be used in a production environment.
2.
Extract and run the setup.exe for MySQL & MyODBC
Install
MySQL to c:\mysql
Install MyODBC
3.
Open Notpad and enter the following information:
Save
it to Windows Root Directory Usually (C:/WINDOWS)
Save
it as my.ini
Note:
If
notepad does not keep the exstension, then place quotes around
my.ini, this will make notepad keep that exstension. However
notepad should keep a .ini exstension.
