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

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Products

Sage 100 ERP


Description

"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.


Disclaimer

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.


Cause

  • 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.


Resolution

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


Category

Configuration

Settings and preferences


Entitlement

Sage 100 ERP


Sage KB ID

35264