There are two distinct sections in the .odbc.ini file. At the beginning, there is a section named [ODBC Data Sources] containing a list of the DSN and the matching installed driver pairs, for example:
[ODBC Data Sources]
Oracle=
TSS 17 Oracle Driver...
where Oracle is the data source name and TSS 17 Oracle Driver is the associated driver for the Oracle database.
The next section named [ODBC] allows ODBC tracing. This capability allows you to trace calls to ODBC drivers and create a log of the traces for troubleshooting purposes.
Configuring Authentication for TSS 17 SQL Server Driver on UNIX
To configure SQL Server or Windows authentication for a TSS 17 SQL Server Driver on a UNIX system, modify the odbc.ini file to use the correct authentication values:
-
For SQL Authentication, set
AuthenticationMethod=1
-
For Windows Authentication, set
AuthenticationMethod=9