How to set up an ODBC connection
In order to set up an ODBC connection, you must specify four things:
- The name of the data source(DSN).
- The driver used to access the data (e.g SQLServer).
- The registration type(per user/per machine).
- The connection attributes: these include all the information required to access the data and are specific to each driver. They are given in the form of "name=value".
The ODBC API takes these attributes in a generic way (in a string containing pairs "name=value"), so Windows Installer has no other way and neither does Advanced Installer.