Error: "Failed to retrieve data from database" / "Failed to retrieve data set" / "Report operation failed" / "Table [Table] could not be found" (Role does not have ODBC Read access)
Description
For chat assistance: Chat Now
Cause
The user does not have ODBC read rights in Sage 300 Construction and Real Estate Security Administration.
Resolution
[BCB:2:Database warning:ECB]


[BCB:5:Third-party support:ECB]


Grant the user's role ODBC read access:

  1. Open Sage Desktop as an Application administrator
  2. Form the Tools or Options menu, select Security Administration.
  3. From User Setup, Locate user and identify role used for printing report that is generating the error. Exit User Setup.
  4. From Role Setup, select the role identified in step 3.
  5. Expand Tasks, ODBC and check the Read Access check box to grant permission to this role.  
  6. Click Save and exit Role Setup
  7. Have the user close Sage 300 Construction and Real Estate and then log back in. User will now be able to print report without error.
Steps to duplicate
Related Solutions

Error: "Failed to retrieve data from the database" (ODBC DSN not configured properly)
Error: "Failed to retrieve data from the Database" (Troubleshooting)