Consult experienced advanced,
Database host using DataSnap + SQL Server2008,
Client side to perform any query will not have errors,
But the Client side ApplyUpdates (0) will appear the following error message:
Remote Error: Access violation at address 00913 ff7 module in DataSnapServer. Exe...
It's no problem for me to use inert directly into,

But I have not happen this mistake in the unit, but I this machine installation is SQL Server 2014 Express,
Should be SQL Server version of the question,
I don't know whether what place is not set?
Please experienced ones advanced instruction, thanks.

CodePudding user response:

This is Delphi ClientDataSet problem, I am never entirely by ApplyUpdates (0) to Update data, dropped the code updates, instead of SQL Update statement to implement updates,

CodePudding user response:

When using DataSnap also encountered this error, but the client connection is too much, once had been unable to run normally, don't know if it bugs, I modified the Vcl. After tracking Forms in the cell FindGlobalComponent function (red part, simple and crude, skip) can avoid the error, as follows:
For I:=0 to Screen. Do DataModuleCount - 1
The begin
Result:=Screen. DataModules [I];
//prevent module is partially release (the name set to nil) caused by the wrong address can't continue to execute
try
If CompareText (Name, Result. Name)=0 then the Exit;
the except
The Continue;
end;
end;

Will not affect the execution of the program, but will lead to a memory leak can not be sure, you can try

CodePudding user response:

Upstairs to modify, delete the Delphi a protect themselves!

CodePudding user response:

Through stored procedures to handle, strong maintainability,

CodePudding user response:

Do you have any questions when you look at the Midas. DLL

CodePudding user response:

Access violation at address 00913 ff7 module in DataSnapServer. Exe...

All say the wrong in the DataSnap server

CodePudding user response:

Apparently the server problem yo