Return table data with Delphi ISAPI

Question

I first created a regular datasnap application with server and client. In order to get data from server I have sqlconnection connected to DSProviderConnection and that is connected to ClinetDataSet. Then all I have to do is set ClientDataset commandText and open it.

But with ISAPI I am not sure how to achive the client side connections. For now I have DSRestConnection on CliendModuleUnit. Can I still have SQLConnection and DSProviderConnection on it too. If Yes then I am not sure how to set properties for SQLConnection with ISAPI.

I basically want to pass database table data from server to client in an ISAPI datasnap applicaiton. And just display the data in grid. Please let me know if there is other better ways to do this.

I am using XE6.

Answer 1

You just need to set the host/url where your datasnap server listens for incoming connections. Where is it, depends on how you configured the web server:

http://docwiki.embarcadero.com/RADStudio/XE6/en/Connecting_the_Client_to_DataSnap_Server