The Driver Manager on UNIX and Linux supports file data sources. The advantage of a file data source is that it can be stored on a server and accessed by other machines, either Windows, UNIX, or Linux. See Quick Start Connect for a general description of ODBC data sources on both Windows and UNIX.A file data source is simply a text file that contains connection information. It can be created through the Linux ODBC Administrator (see Configuration Through the Administrator) or it can be created with a text editor. The file normally has an extension of .dsn.It must contain all basic connection information plus any optional attributes. Because it uses the "DRIVER=" keyword, an odbcinst.ini file containing the driver location must exist (see DSN-less Connections).If no path is specified for the file data source, the Driver Manager uses the DefaultDSNDir property, which is defined in the [ODBC File DSN] setting in the odbc.ini file to locate file data sources (see Configuration Through the System Information (odbc.ini) File for details). If the [ODBC File DSN] setting is not defined, the Driver Manager uses the InstallDir setting in the [ODBC] section of the odbc.ini file. The Driver Manager does not support the SQLReadFileDSN and SQLWriteFileDSN functions.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |