MySQL & ASP tutorial [Just added: dsn-less]
Learn how to Install MySQL, import an Access database into MySQL database, and display data on a ASP page. Step by step tutorial with screenshots! Please leave questions or comments.. Updates: I have included a dsn-less connection!
Original Author: snowboardr
Code
UPDATE
- DSN-LESS connection click here.
MySQL
& ASP
MySql Database
Using
a MySql database in ASP is pretty simple, but it's hard to come accross
a straight forward tutorial on ASP & MySQL. So here it is, a mysql tutorial
for you.. Enjoy!
1.
Start by downloading the latest version of MySQL at http://www.mysql.com.
versions are listed to the right on the front page.
next page you will find different OS's, download the windows version.
the mirror closes to you and start the download!
2.
Extract and run the setup.exe file
to c:mysql
3.
Open Notpad and enter the following information:
to Windows Root Directory (C:/WINDOWS)
as my.ini
[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data
4.
Open Windows command prompt.
> Programs > Accessories > Comand Prompt
following:
C:/mysql/bin
C:mysql/bin>mysqld-nt --install
5.
The service is now installed. It can be started and stopped with the Windows
Service manager, or the NET START/STOP commands.
6.
Now download MyODBC which is the driver to connect to mysql from within
ASP.
right side click MyODBC_VERSION#
the exe and install
7.
A nice program to have when using MySQL is MySQL-Front which is a pretty
easy to understand program that access your mysql database(s).
8.
Start up MySQL front.
New
connect whatever you like..
IP: Localhost or Your IP
can be left as root for now..
connect.
click root@localhost and click create new database.
new database tutorialdb
Page
2 - MySQL Database
9.
Entering data into the database can be done several ways, manualy in MySQL-Front
or by Importing from another database. Here we are going to import this
database: Download
database
10.
Im-/Export > ODBC Import
11.
Check the MS Access File radio button then tables will load in the table
list box below, select the tables you want to important and then click import.
12.
Now you can view the table and its data.
Loading Comments ...
Comments
No comments have been added for this post.
You must be logged in to make a comment.