4. Enter a label for your new connection in the Connection Name field.
652
Incorporating Dynamic Data Part IV
5. Verify that the information in the Driver field is correct. If you are defining a Custom JDBC connection,
enter the driver name as specified by the manufacturer. All standard Dreamweaver JSP
drivers display the required syntax in the URL field; user-supplied parameters are surrounded
with brackets.
6. If you are using a standard Dreamweaver JSP driver, replace the bracketed parameters with the
information for your connection. For example, the supplied MySQL driver URL is
jdbc:mysql://[hostname]/[database name]. If I were using a database named
dbaEvents on a server named euripedes, my completed URL would be jdbc:mysql://
euripedes/dbaEvents.
7. If you are defining a custom JDBC connection, enter the full URL as required by the driver.
8. If necessary, enter a username and password in the appropriate fields.
9. To limit the available tables, click Advanced and enter the desired Schema and/or Catalog. Not all
databases support the capability to limit tables.
10. To ensure that your connection is properly set up, click Test. If the connection is established,
Dreamweaver reports success.
11. When you??™re finished, click OK to close the dialog box.
Pages:
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158