Database Connection Error After Install

From WebWatchBotWiki
Jump to: navigation, search
 Share 

SUMMARY

During install, if the option “Run After Install” is checked, WebWatchBot Manager opens and executes without error. Thereafter, when WebWatchBot is opened, an error occurs

SYMPTOMS

Applicable to Windows Vista and Windows Server 2008

The following error occurs (or similar):

Cannot connect to database CWWBGuiView::LoadWatchListCtrlSettings CDBCoreEx::CaptureError: Microsoft OLE DB Provider for ODBC Drivers Error: -2147467259 Msg: Unspecified error Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Query Execution Count: 0

Database connecting string is empty or you do not have permission to access the registry. Check permissions and/or re-install WebWatchBot.

CAUSE

The problem is caused by the logged in user not having an elevated permission to access the registry to read a value for the database connection string.

WebWatchBot uses the Windows Installer which installs any product with an elevated user account that is actually not the one you have logged in with. When you install WebWatchBot (and check the box to run WebWatchBot Manager after install – the GUI), the GUI will open up without error; however, when you close the GUI and open it again, you are getting an error. The error is that your currently logged in user account cannot access certain keys in the registry. The direct cause of this is related to UAC (User Access Control), AD, and using a Windows domain user account.


RESOLUTION

  1. Try logging in with a local Admin account – not a domain Admin account.
  2. Disable UAC (User Access Control)
  3. Create a shortcut on your desktop, then right-clicking and selecting “Run As Administrator” (even if you are logged in as an admin, it will elevate your user account when UAC is enabled).
  4. Check the permissions on all keys and values in the following location in the registry for any user that will access the GUI.
    32 bit location: HKEY_LOCAL_MACHINE\SOFTWARE\ExclamationSoft\WebWatchBot\{version number}
    64 bit location: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ExclamationSoft\WebWatchBot\{version number}