Error
You receive the error ‘An error occurred executing SQL statements GPS Error: 58 SQL error: 58 ODBC Error: 58 Try reviewing the SQL Script for validity.’ when in the Dynamics GP Toolbox System Settings window.
Cause
This error is due to a bug. It occurs if you have both the Dynamics GP Toolbox and Auditor installed. This bug has been resolved in the following builds.
10.0.17
2010.0.16
2013.0.3
If you are experiencing this issue, install the latest build for Dynamics GP Toolbox.
Workaround
If you are experiencing this issue and are unable to install the latest build at this time, here are the steps for a workaround.
1. Open your Auditor Registration window under Microsoft Dynamics GP | Tools | Setup | Auditor | Auditor Setup.
2. Click Registration.
3. Cut and paste the keys into a Notepad document. (Your Auditor keys will show as invalid.)
3. Save the Notepad document for future reference
4. Open the Toolbox System Settings window under Microsoft Dynamics GP | Tools | Setup | Dynamics GP Toolbox | System Settings.
5. Enable the Tools you wish to use.
5. Close the Toolbox System Settings window
6. When finished, open the Auditor Registration Key window
7. Enter your registration keys you saved in the Notepad document
8. Click Ok to validate your Auditor Registration Keys
These steps will need to be repeated if/when you wish to change the Toolbox System Settings.