Error: "Report Execution Error : ERROR S0000 ProvideX ODBC Driver FILEIO Table is not accessible Number : -2146232009

From Sage Intelligence Knowledgebase
Jump to: navigation, search


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.


Network Warning

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