• Sage 300 2022 - What ODBC we need or must use to setup companies/system ODBC?

    Hi everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Error "unable to connect to the database (error=98)"

    Googled my fingers off trying to resolve this. Looking for any help. Installing Sage 300 ERP 2012 and Pervasive PSQL v11.2 on a local computer. (no server is being used for Sage or data) Running on Windows 7. Pervasive database setup goes ok. (32bit…