I am using these components but am having the following error when trying to open the ClientDataSet.
Generate error:
Access violation at address 50FCDC6F in module 'dsnap230.bpl'. Read of address 00000000.
TDFConnection for connection to the bank
TDFQuery with sql query from a table to test
TDataSetProvider with the DataSet property bound to TDFQuery, activating the poAllowCommandText properties is poPropogateChanges
TDataSetClient connected to the TDataSetProvider in the ProviderName property
add ' MidasLib ' to uses where you have your ClientDataset to make the remote connection with dataSetProvider .
Try using the FDMemTable component instead of the ClientDataSet and instead of using the DataSetProvider use the FDQuery .Data and MemTable .Data to pass the content. After I started doing this I did not have any more headaches with ClientDataSet. Example:
if (FDQuery.Active) then
FDQuery.Close;
FDQuery.SQL.Clear;
FDQuery.SQL.Add('SELECT CAMPO FROM TABELA');
FDQuery.Open;
FDMemTable.Data := FDQuery.Data;