Report Desk: Resolution of Pervasive.Data.SqlClient.dll

Report Desk: Resolution of Pervasive.Data.SqlClient.dll

Release Date: TBA
Version 8.6

Actian/Pervasive introduced a bug in versions 12 and 13 of their SQL client regarding LongVarChar columns exceeding 64K in length.  This bug could impact Report Desk.  They have provided us a fixed version of Pervasive.Data.Sql.Client.dll.  We have further patched its .NET version from 4.3.0.0 to 4.3.4030.91789, to allow that version specifically to be loaded instead of 4.3.0.0, which may be in the Global Assembly Cache (GAC).

First, we built ELRWSupport with a reference to this fixed, patched version of Pervasive.Data.SqlClient.dll, so that is the version that will try to load.

Then, when Elliott starts up, we use the following procedure to make this work for us now and in the foreseeable future:

  •  At Elliott startup, determine if we are running on the network – if so, nothing to do.
  • Otherwise (running in local or in hybrid mode):
  •     Query the version of SQL client as we presently do (API call 26).
  •         If the returned version is less than v12 or greater than v13:
  •             Delete Pervasive.Data.SqlClient.dll from the Bin85 directory, if it exists.
  •             Start the synchronization indicating that it should ignore Pervasive.Data.SqlClient.dll.
  •         Otherwise, start synchronization as usual.

 This will result in a version of the SQL client that works for v11, v12, v13 and higher.

JEG
NWSMSYNC.PL, NWSMLOGN.CBL, EL850SY.cs


    • Related Articles

    • Report Desk: Developer Documentation Roadmap

      Release Date: 5/20/2023 Version 8.6 The following articles are available to Report Desk developers: Data Structures Report Desk Tables : A description of the database tables used by Report Desk. Data Structures for Defaults and Enforcements : How ...

    • Data Structures for Report Desk Defaults and Enforcements

      Release Date: 9/19/2022 Version 8.6 and Higher In Report Desk, users can save their input values, as well as output option in templates and re-use them in the future. On the first Report Desk screen, the system prompts you to input the selection of ...

    • Report Desk: Customizing Reports

      Release Date: 4/28/23 Version: 8.6 Customizing Reports Once a user has been given rights to modify Elliott Report Desk User Design Reports (UDR), they will have access to two additional buttons on the report parameter screens. SQL: This button will ...

    • Problems with Using Pervasive Rebuild Utility on APOPNFIL and AROPNFIL Tables

      Q - Recently, we used Pervasive's rebuild utility to rebuild all Elliott database tables (i.e., all \Elliott7\DATA\*.BTR files). After the rebuild, we noticed some strange things happening to our A/P and A/R modules. For example, below is a sample of ...

    • Report Desk: Setup and Configuration

      Release Date: 4/28/23 Version: 8.6 Report Desk provides a powerful developing environment for Netcellent to deliver modern reports with rich elements of proportionally spaced fonts, graphics and line drawing. It allows us to output reports to PDF, ...