Delay Reading Data - TSS SQL Server Driver - 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
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

Problem:

Using the TSS 17 SQL Server Driver, you attempt to read the SQL Server database from the Control Center by clicking the preview option in the Create Entity wizard. If you click preview multiple times, the Control Center hangs. In addition, activities that connect to a database (load data, preview) may take a long time to disconnect and complete even though all data appears to have been processed.

Solution:

Configure the TSS 17 SQL Server Driver and set the parameter EnableScrollableCursors to 3.

To configure EnableScrollableCursors value

  1. Open the ODBC Data Source Administrator window.

  2. Open the DSN for the TSS 17 SQL Server Driver, then open the Advanced tab of the ODBC SQL Server Wire Protocol Driver Setup window.

  3. In the Extended Options section, add EnableScrollableCursors=3.

  4. Click Apply ad then OK to save your changes.