odbc.ini details - trillium_discovery - trillium_quality - 17.1

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

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.