Tutorial: GoDaddy Hosting, Asp w/ Access
Each web host likes to have their customers create databases & connect to them a little differently. These are reasonably simple things to accomplish if your host’s process is well-documented. Unfortunately, this is not always the case. For hosting with GoDaddy (godaddy.com), follow these steps to set up an Access database.
1. In Dreamweaver©, open any asp page & go to the Application panel, then to the Databases tab.
2. Click the plus button (+) immediately below the Databases tab label.
3. Choose "Custom Connection String" from the two options.
4. In the resultant dialogue box, enter the following on one line, but do not yet click OK:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/hosting/username/access_db/database.mdb;"
5. Replace "username" for your own. Do the same with the database name. Note that the directory "access_db" is above (outside) your remote site location ("wwwroot" or "public_html"). That is where your database must go to be recognized (some hosts do this for added security). A little connectivity dance in Dreamweaver will take care of this. Click OK.
>> You will need to do the following every time you wish to update your database, unless you build or buy a content management system (CMS). If you have not modified your database since you last uploaded it to your server, move on to the following steps. If you have, synchronize your site first. <<
6. In Dreamweaver©, go to the Site dropdown menu. Choose 'Manage Sites...'. Select the site definition for your current site & click 'Edit...'.
7. In the Advanced dialogue, choose the Remote Info category. In the area to the right, find the section for 'Host Directory'. Change it to be blank. Click OK to get out of the dialogue boxes.
8. In the Files panel, choose the Files tab. Connect to your remote host (click the first icon below the site name - looks like an electrical plug). In the second roller button (to the right of your site's name), choose 'Remote view'. & you will see a list of folders. One of these will be "access_db", and another will be either "public_html" or "wwwroot".
9. Open the folder that contains your site (either "public_html" or "wwwroot"). Locate your database. Copy it into the "access_db" folder. The database should now be available to the site.
If not, you may also need to tell GoDaddy that the database is there. Do this via their online control panel. See screenshots in the Php/MySql version for context. In the Databases category, click on the Access link. Fill out the resultant screen. You may also have to wait up to 30 minutes or so for GoDaddy to process this request. Your database may not be available until this is done.
>> Don't forget to put your site definition in Dreamweaver© back the way it was. If you don't, files will get uploaded to the wrong directory & your site will become an utter mess. Follow the steps below to remedy this. <<
10. In Dreamweaver©, go to the Site dropdown menu. Choose 'Manage Sites...'. Select the site definition for your current site & click 'Edit...'.
11. In the Advanced dialogue, choose the Remote Info category. In the area to the right, find the section for 'Host Directory'. Change it to say "wwwroot/" (or "public_html/", whichever is appropriate. Click OK to get out of the dialogue boxes.
1. In Dreamweaver©, open any asp page & go to the Application panel, then to the Databases tab.
2. Click the plus button (+) immediately below the Databases tab label.
3. Choose "Custom Connection String" from the two options.
4. In the resultant dialogue box, enter the following on one line, but do not yet click OK:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/hosting/username/access_db/database.mdb;"
5. Replace "username" for your own. Do the same with the database name. Note that the directory "access_db" is above (outside) your remote site location ("wwwroot" or "public_html"). That is where your database must go to be recognized (some hosts do this for added security). A little connectivity dance in Dreamweaver will take care of this. Click OK.
>> You will need to do the following every time you wish to update your database, unless you build or buy a content management system (CMS). If you have not modified your database since you last uploaded it to your server, move on to the following steps. If you have, synchronize your site first. <<
6. In Dreamweaver©, go to the Site dropdown menu. Choose 'Manage Sites...'. Select the site definition for your current site & click 'Edit...'.
7. In the Advanced dialogue, choose the Remote Info category. In the area to the right, find the section for 'Host Directory'. Change it to be blank. Click OK to get out of the dialogue boxes.
8. In the Files panel, choose the Files tab. Connect to your remote host (click the first icon below the site name - looks like an electrical plug). In the second roller button (to the right of your site's name), choose 'Remote view'. & you will see a list of folders. One of these will be "access_db", and another will be either "public_html" or "wwwroot".
9. Open the folder that contains your site (either "public_html" or "wwwroot"). Locate your database. Copy it into the "access_db" folder. The database should now be available to the site.
If not, you may also need to tell GoDaddy that the database is there. Do this via their online control panel. See screenshots in the Php/MySql version for context. In the Databases category, click on the Access link. Fill out the resultant screen. You may also have to wait up to 30 minutes or so for GoDaddy to process this request. Your database may not be available until this is done.
>> Don't forget to put your site definition in Dreamweaver© back the way it was. If you don't, files will get uploaded to the wrong directory & your site will become an utter mess. Follow the steps below to remedy this. <<
10. In Dreamweaver©, go to the Site dropdown menu. Choose 'Manage Sites...'. Select the site definition for your current site & click 'Edit...'.
11. In the Advanced dialogue, choose the Remote Info category. In the area to the right, find the section for 'Host Directory'. Change it to say "wwwroot/" (or "public_html/", whichever is appropriate. Click OK to get out of the dialogue boxes.