Click Finish when you??™re ready. A setup dialog box for the driver selected
appears next. Each setup dialog box is somewhat different.
If you don??™t see a driver for your database listed here, get one from the manufacturer or database
sponsor. If you are working with MySQL databases, you can get an ODBC driver from
www.mysql.com/downloads/api-myodbc.html.
TIP TIP
NOTE NOTE
644
Incorporating Dynamic Data Part IV
5. In the setup dialog box, enter the Data Source Name and select the data source. Following are
examples of the most commonly used data sources:
n For Access databases, click Select to locate the database (see Figure 19-4). If a username and
password are required, click Advanced to enter that information.
n For Excel spreadsheets, choose Select Workbook to locate the proper file. Select Options to
limit the number of rows accessed.
n For SQL Server, select a name from the Server drop-down list. Choose (local) if your system
also acts as the SQL Server. Click Finish when you are done.
n For MySQL databases, enter the MySQL host name or IP address and the full path to the
MySQL database. You can enter a username and password on the same screen. The MySQL
ODBC driver also offers a wide range of options you can enable.
FIGURE 19-4
To use an existing Access database, click the Select button from the ODBC Microsoft
Access Setup dialog box.
Pages:
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148