Icon View Incident Report

Serious Serious
Reported By: Brian Martin
Reported On: 10/25/2012
For: Version 4.34 Build 2
# 3667 Mixing 32-bit Clients with 64-bit Server Can Cause Access Violation with Parameterized SQL Statement

I have also be running the 64-bt version on a different dev server… and have hit a problem… when inserting a large string into a memo field:

DBISAM Engine Error # 11279 An unknown error ('Access violation at address 000000000040645B in module 'dbsrvr.exe'. Read of address FFFFFFFFFFFFFFFF') occurred with the connection to the database server at '10.10.10.142', please check the server log.

The query used for the insert is as follows.

procedure TForm1.Button1Click(Sender: TObject);
var
   TempStrings: TStrings;
begin
   TempStrings:=TStringList.Create;
   try
      with DBISAMQuery1 do
         begin
         ParamByName('serviceId').AsInteger:=42;
         ParamByName('clientref').AsString:='';
         ParamByName('visibility').AsString:='';
         ParamByName('userId').AsString:='Fixzone';
         ParamByName('complaintcategory').AsInteger:=0;
         TempStrings.LoadFromFile('c:\temp\notes.txt');
         ParamByName('notes').AsString:=TempStrings.Text;
         ParamByName('saediFromID').AsString:='JTM498';
         ParamByName('saediToID').AsString:='';
         ParamByName('Function').AsInteger:=0;
         ParamByName('Communication').AsString:='';
         ParamByName('Complaint').AsInteger:=3;
         ExecSQL;
         end;
   finally
      TempStrings.Free;
   end;
end;



Comments Comments
The issue was caused by the BLOB (Memo) parameter. There was still an issue with how BLOB parameters were sent back and forth between 32-bit applications and 64-bit servers, or vice-versa.


Resolution Resolution
Fixed Problem on 10/26/2012 in version 4.34 build 3


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image