Connecting Dreamweaver to MySQL & Chilisoft ASP

A short tutorial on connecting to a MySQL database using Sun/Chilisoft ASP and Dreamweaver MX (or Ultradev 4).

Step 4 - Dreamweaver

Ok, now Chilisoft is ready, your PC is ready, lets hook up Dreamweaver!

First things first, let's take a quick look at what we're actually doing. In the diagram to the right, you can see the two separate DSNs that we created and the MySQL database itself. Note that the DSNs never actually talk to one another. They each connect to the database separately and if anything changes to the configuration of one, you must also change the other.

Launch Dreamweaver and open the site you are connecting to this database. Add a Data Source Name (DSN) connection using the following parameters:

Connection Name:	The name you want to use in dreamweaver to refer to this database.
DSN:	To make this work properly, go down to the connection and select Using Local DSN, then select the DSN you created in step 3.
User Name:	If you entered a user name in steps 2 & 3, you don't need one here unless the user is different for development.
Password:	If you entered a password in steps 2 & 3, you don't need one here unless the user is different for development.

After setting up your configuration, make sure you click the Test button and make sure you can connect to the database. You should see a dialog that indicates that the connection was successful. Once everything is working, your database will appear in the Databases window and you will be able to create Bindings for use in your pages!

Greg Olone

Greg Olone Greg is the President & Owner of Stretched Out Software Inc, a flourishing web & multimedia programming company located in Jacksonville, FL USA. With a background in programming and a degree in Computer Animation, the internet has become my playground.

Unless otherwise noted, all of Greg's extensions are Mac & PC compatible!

See All Postings From Greg Olone >>

Comments

Be the first to write a comment

You must me logged in to write a comment.