How to prevent the database AutoClose property from being reset

How to prevent the database AutoClose property from being reset

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

    • Related Articles

    • How to disable AutoClose in SQL Server 2005

      Summary This article explains how to disable the AutoClose database property for SQL Server 2005 databases. More Information There is a feature in the database engine that SWCS uses, Microsoft SQL Server Express Edition, that causes it to ...

    • Performing advanced database tasks with SWCS 4.2

      Summary This article explains how a user can perform advanced database management tasks on a SWCS 4.2 company database. More Information The Solatech Window Covering Software version 4.2 uses Microsoft SQL Server 2005 as it's database engine. During ...

    • How to use the Replace feature in Solatech Focus

      How to use the Replace feature in Solatech Focus Summary Solatech Focus users have the ability to replace products and/or options quickly on an existing quote or sale. This knowledge base article provides instructions on how to use this feature. ...

    • Your database has reached the maximum size allowed

      Summary When a company is opened you receive the following message: Warning: Your database has reached the maximum size allowed. To prevent loss of data you cannot use this company database until it has been reduced in size. Please contact Solatech ...

    • Update Company Database for QuickBooks Desktop Invoice Exporting

      Summary This package will update the company database so that invoices for QuickBooks Desktop (QBD) can be correctly exported from SWCS (SalesPRO). Without this package the sales tax is not included in the invoice export which will prevent it from ...