| 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: - Open Sage Desktop as an Application administrator
- Form the Tools or Options menu, select Security Administration.
- From User Setup, Locate user and identify role used for printing report that is generating the error. Exit User Setup.
- From Role Setup, select the role identified in step 3.
- Expand Tasks, ODBC and check the Read Access check box to grant permission to this role.
- Click Save and exit Role Setup
- 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.
|
|