Tools
Rss Categories

ExecuteReader requires an open and available connection

Views: 542 Created: 2016-07-21 11:18 Last Updated: 2016-08-11 12:00

SYMPTOM

The following error displays randomly within the software:
“ExecuteReader Requires an Open and Available Connection”.

CAUSE

This error usually indicates database corruption. Databases can become corrupt from power outages, improper shutdowns, or failing hard drives.

RESOLUTION

Procedure 1 (Force-close the program and reboot)

  1. Access the Windows Run window by pressing the Windows key and R key on the keyboard.
  2. Type "taskmgr" without the quotes in the Open field.
  3. Click OK.
  4. Choose the Yearli program in the list of running applications. It may be listed as GNWFPlus.exe.
  5. Click End Task.
  6. Reboot the machine.
  7. Open the Yearli program.

Procedure 2 (Enable SQL Protocols and Restart SQL instance)

Note: If this is a network version of Yearli, these steps will need to be taken on the server machine.

  1. Access the Microsoft SQL Server Configuration Manager. For steps to do this see the How do I access SQL Server Configuration Manager? article.
  2. On the left, double click on SQL Server Network Configuration.
  3. Choose Protocols for YD2015_SS8E*.
  4. If Shared Memory is Disabled, right click on Shared Memory and choose Enable.
  5. If Named Pipes is Disabled, right click on Named Pipes and choose Enable.
  6. If TCP/IP is Disabled, right click on TCP/IP and choose Enable.
  7. Choose SQL Server Services.
  8. Right click on SQL Server (YD2015_SS8E)*.
  9. Choose Restart.
  10. Open the Yearli program to see if the issue persists.

*The SQL Server instance will differ depending on the version of the program. The SQL servers associated with each version of the program are:

  • Winfiler 2012 - 2013: WF_SS8E
  • WinFiler Plus 2013 - 2014: WFP_SS8E
  • Yearli 2014: WFP_SS8E
  • Yearli 2015 - Current: WFP_SS8E or YD2015_SS8E
APPLIES TO

  • Winfiler 2012 - 2013
  • Winfiler Plus 2013
  • Yearli 2014 - Current