When an application program uses a file DSN, it can connect to a data source without obtaining information from ODBC.INI or the registry because the DSN file stores information for connecting to the data source.

By sharing the file, multiple users can connect to the HiRDB system without having to register the data source (formerly the machine data source) to each machine. A file DSN can be used when the ODBC component version is 3.0 or higher.

File DSNs can be created by the ODBC data source administrator.

Creating file DSNs

To create a file DSN, select a file DSN, add the file DSN, select a driver (HiRDB 32-bit driver), and then specify the storage file name. A connection request is then issued to the HiRDB system, and the driver manager creates the file based on the complete connection character string returned by SQLDriverConnect. However, in this case, the password is not stored in the file DSN. If the password is to be shared, add the line PWD=password to the created file.