Part1: What do I need to setup a server on my computer?
For this to work you will need to have the software below installed.

1. Dreamweaver 8, this is what I used in the tutorial. I am not sure if you can do this on the previous versions.

2. Windows XP Professional

3. (IIS) Internet Information Services has to be installed.

Part2: Preparing my computer.
If you are positive that you installed IIS (Internet Information Services) you can skip this step. To install IIS you will need the windows XP Pro CD. Put the CD Rom in to the tray and it will auto run. Click on Install Optional Windows components.

When you do that it will launch the Windows Components Wizard scroll down until you see the Internet Information Services

Click on the Next button and follow the instruction to install it.

Now, click on Start   Control Panel Administrative Tools now double click on the Internet Information Services icon.

Right click on Default Web Site click New Virtual Directory

Click Next and you will see the Alias window, this name will represent the name of the folder that all your sites will be stored in. So when you preview your site it will load up as  http://localhost/myfoldername/mysite

For the name I would use some thing general, like mysites, mywebpages.

Part3: Start up Dreamweaver.
By you installing IIS, it will automatically create a folder located in you C:\ Driver called Inetpub. If you look inside the Inetpub folder you will see a folder called wwwroot. You will have to place you sites inside the wwwroot folder. So your site directory will look like this: C:\Inetpub\wwwroot\mysite\

Start up Dreamweaver and click Site Manage Sites..

and click New Site. Click on the Advanced Tab and you will see the window below. Click on Local Info and fill in the information according to the image. When you click on the yellow folder, browse to the C:\Inetpub\wwwroot\ folder, create a new folder called "mysite" open and select that folder. This folder will be where all your sites information will be stored. For the "Default Image Folder"  create a folder located in C:\Inetpub\wwwroot\mysite\ called images. So the image Directory will be C:\Inetpub\wwwroot\mysite\images\ 

Now Click on "Testing Server" and fill in the information shown below.

Next click ok, you will see a warning message just click ok, Done.

Part4: Setting up the Database connection.
Download these files download the pack they include a image folder and a database folder. Place these folders in side yousite folder. For Dreamweaver to access the database file you will need to set the security of the folder to give permission to asp.net. Click on My Documents, Tools Folder Options and click on the View tab. Scroll down and uncheck Use simple file sharing, if it is already leave it alone. Close those windows when you are finished. Browse back to you database folder, C:\Inetpub\wwwroot\mysite\Database\ 

Right click on the database folder and click properties. When you do that you should see the window below.

Click on the Security tab Add Advanced Find Now Select ASPNET from the list and hit ok twice.

To set the permissions check Full Control, this is just a fail safe. With that setup we can now set up the system DNS. click on Start   Control Panel Administrative Tools now double click on Data Source (ODBC) click on the System DNS tab and click Add

Select Microsoft Access Driver(*.mdb) and hit Finish. When you do that the window below will come up.

Change the "Data Source Name" to something relating to your site. Click on the Select button

Browse to the database folder and select the database and click ok. After that just click ok, twice.

Step5: Creating a database connection in Dreamweaver.
Click File New... and click on Dynamic Page ASP.NET VB and click Create. Hit Ctrl+S and save your site as default or what ever you want.

After that click on the Windows tab and make sure Databases is checked.

Click on the Shown in the databases tab and click on OLE DB Connection

With that fill in the information below.

Connection Name: tutbd

Next click on the Build Button and the window blow should come up

From the Provider tab select "Microsoft Jet 4.0 OLE DB Provider" and click Next. With that the window below should come up.

Click on the button next to the "Select or enter a database name" and browse to your database file. Mine is C:\Inetpub\wwwroot\mysite\database\tutdb.mdb

After that Hit the Test Connection Button, and it should be successful. With that click ok. Make sure you connection string look similar to what I have below.

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\mysite\database\tutdb.mdb"

At this point you should be in the OLE DB Connection window, click on the test button

The test should be Successful

Finished:
Well that is it. Hope it is what you expected. If you have, any questions or comments feel free to e-mail me or leave a message on the forum. If you are having a hard time with the tutorial email me and I will try to help.

This Tutorial was Created By Mark
© 2007 pixeldigest.com. All Rights Reserved.