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

    • How to Investigate or Debug Report Desk Problem by Using SQL Statement

      Released Date: 1/25/2025 Version: 8.6 & Higher Report Desk is based on the PSQL relational engine. It sends a SQL statement to the PSQL engine to retrieve data. Sometimes, you don't get the result back as you expected, so what next? For example, when ...

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

    • How to Investigate or Debug Report Desk Problem by Using Registry Keys

      Release Date: 01/25/2025 Version: 8.6 & Up Report Desk is based on the PSQL relational engine. It sends a SQL statement to PSQL engine to retrieve data. Sometimes, you don't get the result back that you expected, so what next? For example, when you ...

    • An Example of DDF Files in DATA Folder Causing Report Desk or Power Search Issue

      Release Date: 03/14/2025 Version: 8.6 & Up Q - When I tried to print a UDR report (i.e., AP Distribution History Report) from company # 98, I got the following error message: Cannot find definition of table APDSTHST in DDFs. You probably are using ...

    • DDF Files in DATA Folder May Confuse PSQL

      Release Date: 04/27/2018 Q - We recently noticed a strange phenomenon where if I try to access Elliott column names in the ARCUSFIL, I find the Customer AR account is defined as CUS_AR_ACCT_NO and it is 24 digits. See sample screen below: I have an ...