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.