6. When you??™ve closed the setup dialog box, click OK to close the ODBC Data Source Administrator.
After you??™ve created a DSN for your data source, you??™re ready to create an ODBC DSN connection in
Dreamweaver. Although the basic procedure is the same for all five server models, the specific steps are different
enough to warrant the individual descriptions presented in the following sections.
645
Establishing Connections and Recordsets 19
ASP
A DSN connection is often an ASP developer??™s first choice for rapid development because of its easy setup.
To establish a DSN connection in Dreamweaver, follow these steps:
1. Choose Window ??? Databases to display the Databases panel, as shown in Figure 19-5.
2. Click the Add (+) button and select Data Source Name (DSN) from the drop-down list.
646
Incorporating Dynamic Data Part IV
Afirst step for ASP and ColdFusion users on Windows is to establish an ODBC data source. Although this
operation is not strictly necessary for ColdFusion, it does make it setting up a connection easier.
1. In Windows, choose Start ??? Administrative Tools ??? Data Sources (ODBC).
2. From the ODBC Data Source Administrator, select the System DSN tab.
3. Click Add to open the Create New Data Source dialog box.
4. Select the Microsoft Access Driver (*.
Pages:
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149