Delay Reading Data - TSS SQL Server Driver - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

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.