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
  1. Log into Sage Desktop as an Application Administrator.
  2. From the Options menu, select Security Administration.
  3. 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.
  4. On the Tasks tab, expand Tasks, then expand ODBC.
  5. Select the check applicable check boxes for Read Access and Write Access.
  6. Click Save Changes.
    Note: Changes will take effect when the user next logs in to Sage 300 Construction and Real Estate.

DocLink: How do I give users access to setup, tasks, tools, reports, or inquiries?
DocLink: Error: "Failed to retrieve data from database" (non-Application Administrators unable to print Billing invoice formats)
DocLink: Error: "[file name] file is incompatible. The current security settings prohibit this file from being upgraded automatically.
DocLink: Error: "Failed to retrieve data from the Database" (Troubleshooting)

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles