• Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • Linked Server Connections Failing in SQL 2014 through ODBC

    We have installed 64 bit ODBC driver and the Sage 100 Standard ERP 2014 workstation software on our new Windows server 2012 Datacenter server with SQL 2014 Standard. The system's ODBC connections have been configured and can access the table count and…