Elliott 8.6 to Distribute 4.4 PSQL Entity Framework Client

Elliott 8.6 to Distribute 4.4 PSQL Entity Framework Client

Release Date: 11/2/2022
Version: 8.6 & Up

In Elliott 8.6, we distribute PSQL 4.4 Entity Framework Client for Avalara interface (national sales tax collection). You can expect to see the following DLL file in the Elliott BIN86 folder:

  • Pervasive.Data.SqlClient.Entity.dll

This DLL is version 4.4, which comes with both PSQL 14 and 15. But their revision levels are slightly different. The one we distribute is from PSQL 15.  We provide the following information for our users:

  • If the user is on the PSQL 15 client, then Elliott 8.6 (with Avalara operations) will load this client from the GAC (Global Assembly Cache).
  • If the user is on the PSQL 13 client, then Elliott 8.6 will load this client from the BIN86 folder. The Entity Framework client that comes with PSQL 13 is 4.3 won't work with our Avalara interface. This the reason why we distribute this 4.4 client in the BIIN86 folder to override the 4.3 client that comes with PSQL 13.
  • Based on our in-house testing, PSQL Entity Framework 4.4 client works with the PSQL 13 database engine.  But Actian claims they did not do backward testing of the 4.4 client against the older PSQL 13 server. If you want to eliminate this risk, you should consider upgrading to the PSQL 15 server.
If you right click on this DLL and choose "Properties" and then the "Details" tab, you can expect to see the following version information:


EMK


    • Related Articles

    • A Case Where PSQL 13 Client Is Not Compatible with PSQL 15 Server

      Release Date: 02/04/2025 Version: 8.6 Do Users Need to Upgrade to PSQL 15 Client When Upgrading PSQL Server? We were often asked in the past if our users should upgrade their PSQL 13 client when they upgrade to the PSQL 15 server. In our past ...
    • How Elliott 8.6 Works with Different Versions of the PSQL ADO.NET Client

      Release Date: 11/4/2022 Version: 8.6 & Up Elliott V8.6 starts to use PSQL relational operations. Both Report Desk & PowerSearch features rely on the PSQL relational engine. To use these features, you should refer to the following KB article to set up ...
    • Avalara Setup Procedures - Updating Elliott Tables

      ' Release Date: 4/28/23 Version: 8.6 and Above Updating Elliott Tables Generate States Table If you do not have state table setup yet, go to Accounts Receivable-> Maintenance-> State File -> Generate The system comes with a pre-defined table of all ...
    • Avalara Setup Procedures - Elliott Configuration

      Release Date: 4/28/23 Version: 8.6 and above Revised: 9/11/23 Elliott Configuration After installing Elliott V8.6 for the first time, you will need to make some configuration changes. Bring up <ElliottRoot>\Bin86\EL860CF.exe utility or alternatively ...
    • GLENTMNT General Ledger Financial Entity File Maintenance

      Financial Entity File Maintenance Application Overview The Financial Entity File application enables you to define financial entities within the main G/L Account File. These entities may then be reported upon individually by entering the entity's ...