Error: "Report Execution Error : ERROR S0000 ProvideX ODBC Driver FILEIO Table is not accessible Number : -2146232009
Sage 100 ERP
"Report Execution Error : ERROR [S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible Number : -2146232009 Source : Driver Error : Unknown SQL State : Unknown", occurs when running a report in Sage Intelligence.
This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions.
- The version of Sage 100 ERP not be compatible with the version of Sage 100 Intelligence. For example, Sage Intelligence 4.50 is only compatible with Sage 100 ERP version 4.50; Sage Intelligence 5.0 is only compatible with Sage 100 ERP 2013 (5.0).
- The user may not have the correct ODBC security for the report.
- The company may not have all of the required modules for the report to generate.
The following canned reports are dependant on modules other than General Ledger. Please verify required modules are activated for applicable company code in Sage 100 ERP:
Customer Sales 2-0 (MAS), Dashboard Sales Sub 2-0 (MAS), Top Customers By Product 2-0 (MAS) and Top Products by Customer 2-0 (MAS) use the Accounts Receivable and Inventory Management modules
Inventory Status 2-0 (MAS) use the Inventory Management and Accounts Payable modules
Vendor Purchases 2-0 (MAS) use the Accounts Payable and Purchase Order modules
Note: Report number (i.e. 2-x) may differ depending on Sage Intelligence version
Settings and preferences
Sage 100 ERP
Sage KB ID