Summary
This article explains how to prevent the Solatech Window Covering Software (SWCS) from disabling
the AutoClose database property.
More Information
There is a feature in the database engine that SWCS uses, Microsoft SQL Server Express Edition, that
causes it to automatically close the connection to the database when it's no longer being used. This
has the effect of slowing down the software significantly as a new connection must be opened each
time the database is accessed.
Normally when a company is opened the software checks to see if this property is turned on. If it is
then it's automatically turned off. If you want this property to not get reset automatically then you
need to set a switch in the Registry.
To disable the option to automatically close connections:
- Click Start, Run.
- Type REGEDIT and click OK.
- Navigate to the following key: HKEY_CURRENT_USER\Software\Solatech\Window Covering Software\4.0\Settings (Default).
- Create a DWORD value called "SkipAutoCloseConnectionCheck".
- Double-click on the new entry and set the value to 1.
- Click OK to return to the Registry Editor.
- Close the Registry Editor.
Note: It is not recommended that you disable this setting if you are using a full version of SQL
Server without first consulting with your database administrator.
APPLIES TO
- Solatech Window Covering Software 4.2