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:

1. Click Start, Run.
2. Type REGEDIT and click OK.
3. Navigate to the following key: HKEY_CURRENT_USER\Software\Solatech\Window Covering Software\4.0\Settings (Default).
4. Create a DWORD value called "SkipAutoCloseConnectionCheck".
5. Double-click on the new entry and set the value to 1.
6. Click OK to return to the Registry Editor.
7. 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