Adding Database Functionality - New Perspectives on Adobe Dreamweaver CS5, Comprehensive - page 543

Figure 9-29 Custom Connection String dialog box

◗

3. In the Connection name box, type nbfdb . This is an internal name that is visible
only when you are working in Dreamweaver.

◗

4. In the Connection string box, type Provider=Microsoft.Jet.OLEDB.4.0; Data
Source= followed by the exact file path to your database, and then type ;
(semi colon).

◗

5. Click the Using driver on testing server option button, if necessary, and then
click the Test button. A dialog box opens, stating that the connection was made
successfully.
Trouble? If error messages appear when you click the Test button, you prob-
ably mistyped the connection string. Click the OK button to close the message
dialog box, delete the text in the Connection string box, retype the information,
and then repeat Step 5. If the test is still unsuccessful, verify the file path for your
database with your instructor or technical support person and verify the informa-
tion in the Testing Server category in the Site Definition dialog box. If you still
are having trouble, use an outside FTP program to upload the _mmServerScripts
folder to the root directory on your remote server and on your testing server if you
are using a separate testing server. In addition, verify that the IUSR_SERVER has
been given written permission to the database.

◗

6. Click the OK button to close the message dialog box. The database name appears
in the Connections for Site 'NextBest Fest' dialog box.

◗

7. Click the Done button in the Connections for Site 'NextBest Fest' dialog box. The
dialog box closes.

◗

8. In the Recordset dialog box, type nbf_recordset in the Name box.
If necessary, click the Connection button, and then click nbfdb .

◗

9. In the Database items box, expand the Tables list, click contact to select the
database table, and then click the SELECT button to add the information to the
SQL box.

◗

10. Click the OK button. The Recordset behavior is added to the page and appears in
the Server Behaviors panel. See Figure 9-30.