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
-
Open the ODBC Data Source Administrator window.
-
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.
-
In the Extended Options section, add EnableScrollableCursors=3.
-
Click Apply ad then OK to save your changes.