odbc.ini details - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

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.

Note: The following keywords all control tracing: Trace, TraceFile, TraceDLL, ODBCTraceMaxFileSize, and ODBCTraceMaxNumFiles.

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 

Note: For the latest driver-specific values visit the Progress documentation page by clicking here.