Made a datasnap server and client, Windows 10 + xe7
The server using MYSQL + FDCONNECTION + FDQUERY + DSP
Clients use sqlconnection + clientdataset dspconnection + + datasource + dbgrid, according to

SQL server fdconnection connectionstring, fdquery (select * from tbuser) are in accordance with the default Settings.

The problem is the client form creation, to display as title of a 402 error, what the operation always be performed without the assign the selectcommand.
Client clientdatase commandtext is the select * from tbuser, repeatedly checked the server and the client
I don't know what the reason,

Cellar master know that

CodePudding user response:

As if the MYSQL driver has a problem
The server with a 64 - bit, the client remember also use 64 bits

CodePudding user response:

Determine not mysql driver problem, don't know whether I fdconnection where to set? Or server datamoduleunit inside to set?

CodePudding user response:

Client clientdataset DataSTableName corresponding fdquery controls Settings for the server name,
When designing the clientdataset don't OPEN, when needed to OPEN again,