When running Global Hospitality Suite reports viewer, we receive the following error: R&R Error : DB access: The connection, statement, or query handle you provided is not valid.
This is a known issue with the Arpeggio 12.5 report viewer. In order to work around the issue, an ODBC trace can be enabled on the client PC within ODBC Data Source Administrator. This then allows the report viewer to connect to the database as expected. As this process generates a log file (which will require regular purging), we have compiled the following command line script which performs the following actions:
- Stop any existing ODBC trace by updating the ODBC trace registry key.
- Define an ODBC trace file location within the registry.
- Purge ODBC trace file contents. (GHS must not be open for the purge to be successful).
- Restart ODBC trace within the registry.
The script can be found below and should ideally be setup as a logon script:
reg add "HKCU\Software\ODBC\ODBC.INI\ODBC" /f /v "Trace" /t REG_SZ /d "0"
reg add "HKCU\Software\ODBC\ODBC.INI\ODBC" /f /v "TraceFile" /t REG_SZ /d "C:\Program Files (X86)\DHS\TRACEFILE.LOG"
BREAK>"C:\Program Files (X86)\DHS\TRACEFILE.LOG"
reg add "HKCU\Software\ODBC\ODBC.INI\ODBC" /f /v "Trace" /t REG_SZ /d "1"