Error: "Failed to retrieve data from the database. Details: [Database Vendor Code: 31837]"
Description
Cause
The specific Sage 300 user does not have access to ODBC with Security Administration
Resolution
Log into Sage Desktop as an Application Administrator.
From the Options menu, select Security Administration.
Click Role Setup and select the applicable role. Note: To confirm the roles assigned to the user, click User Setup, select the user and click on the Roles tab.
On the Tasks tab, expand Tasks, then expand ODBC.
Select the check applicable check boxes for Read Access and Write Access.
Click Save Changes. Note: Changes will take effect when the user next logs in to Sage 300 Construction and Real Estate.