System's own DataSnap three-tier architecture DataSnap, and examples of use FireDAC components using TFDConnection transmission link and use TStream way, examples of DataSnap FireDAC controls completed calls in sqlite database,
Ask next, change the MSSQL database can? After I into MSSQL database, have the following error,

Don't msSql database support Tstream transmission way,
-- -- -- -- -- -- -- -- -- --
Procedure TClientForm. GetTables;
Var
LStringStream: TStringStream;
The begin
FDStoredProcGet. ExecProc;
LStringStream:=TStringStream. Create (FDStoredProcGet Params [0]. AsBlob);
Try
If LStringStream & lt;> Nil then
The begin
LStringStream. Position:=0;
DataModuleFDClient. FDSchemaAdapter. LoadFromStream (LStringStream, TFDStorageFormat sfBinary);
end;
The finally
LStringStream. Free;
end;
end;
-- -- -- -- -- -- -- -- -- --
The above process execution to DataModuleFDClient. FDSchemaAdapter. LoadFromStream (LStringStream, TFDStorageFormat. SfBinary); The fault

CodePudding user response:

The bottom of this demo

CodePudding user response:

System take the example of c: \ Users \ Public \ Documents \ Embarcadero \ Studio \ 19.0 \ Samples \ Object Pascal \ DataSnap \ FireDAC

CodePudding user response:

Find the problem, the client need to select two tables, I before is the select all of the fields, then select the main field only, can query succeeded, directly said datasnap through large data stream transmission is multiple data packets, the client accepts the need for treatment, currently in further study,,,,

CodePudding user response:

CodePudding user response:

Delphi xe Datasnap use FireDAC link MSSQL2000
When performing FireDAC connection, the client is always an error, you are way? :
The Exception EIPAbstractError module in the at 00780958
Tip No peer with the interface with
Guid {bb0be5c - 9 of 9 d9e - 485 - e - 803 - d - 999645 ce1b8f} has had been registered.

CodePudding user response:

If you want to change the type of database, can through the connection of control changes,
Such as through TADOConnection connects, as long as change the socket, can,

CodePudding user response:

It is recommended to use json data transmission, the use of flow problem is more,