If you upload a file containing a connection and opt to include dependent files when
you upload it, the connection files are uploaded automatically.
Using Data Source Names (DSN)
Data sources, like graphic files, come in different formats. Databases developed in Access are different from
those developed in Oracle or FoxPro. To enable applications to access a variety of data sources, the Open
Database Connectivity (ODBC) standard was developed. ODBC is a type of universal translator that
enables Web (and other) applications to read from and write to databases by using a specific driver for a
particular database type. Windows systems include drivers for data sources created in Microsoft Access,
SQL Server, dBase, Oracle, FoxPro, Excel, and Paradox. There??™s even a driver for reading straight text files,
which usually contain comma-separated values. Macintosh users should connect to the ODBC drivers on
their testing servers.
The Data Source Name protocol was established to simplify the process of connecting via ODBC. Just as a
domain name, such as www.idest.com, is an alias for an Internet Protocol number (for example,
64.70.242.110), a DSN is an alias for the actual location of a data source. Locally, on Windows systems,
DSNs are managed through the ODBC Data Source Administrator.
Pages:
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146