Dreamweaver Database Setup
Setting up a MS Access database with dreamweaver, for ASP site.
Create ODBC Datasource (in preparation for database setup in dreamweaver):
1. Select Start > Control Panel
2. Double-click Administrative Tools
3. Double-click Data Sources (ODBC)
4. Select System DSN tab
5. Click Add
6. Double-click Microsoft Access Driver (*.mdb)
note: we select Microsoft Access Driver (*.mdb) here, as we are creating a ODBC datasource for a Microsoft Access database file, but a different driver should be selected if you use a different database
7. Enter datasource name, eg. test
8. In Database section, click Select button, to select the ms access database file
9. Browse to the ms access database file, eg. test.mdb, select this file, and click OK
10. Click OK again, to confirm the creation of the new ODBC datasource
Create New Dynamic Site
1. In Dreamweaver, select Site > New Site
2. Enter name for new site, eg. testasp
3. Enter http address of site, eg. http://localhost/testasp
4. Click Next
5. Select option of ‘Yes, I want to use a server technology’
6. Select ASP VBScript from the server technology dropdown box
7. Click Next
8. Select Edit and test locally (my testing server is on this computer)
9. Click on browse button, and browse to folder where you wish to store your files (i.e. testing server location), eg. c:\inetpub\wwwroot\testasp
10. Click Next
11. Ensure url entered is same as that previously entered, eg. http://localhost/testasp
12. Click Test URL (to confirm URL is accessible) (if url is accessible, then you’ll see message of ‘The URL Prefix test was successful’), and click OK
13. Click Next
14. Select Option of No (we can set up remote server another time)
15. Click Next
16. Click Done, and your new dynamic site is now created
Setup database on dreamweaver
1. In Files panel, right-click root of the site, and select New File
2. enter name for file, eg. testconn.asp
3. double-click this new file to open file (Databases panel under Application panel should now be accessible)
4. In Application panel, under Databases panel, click plus sign, and select Data Source Name (DSN)
5. enter connection name, eg. connTest
6. select DSN, eg. test
7. click Test (if connection is setup properly, you should see ‘Connection was made successfully’), click OK
8. click OK again, to confirm creation of new database connection (your database connection in dreamweaver is now setup)
Comments »
No comments yet.
RSS feed for comments on this post.