Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Database Connectivity for Mobile Application



Permlink Replies: 11 - Last Post: Feb 8, 2018 12:28 AM Last Post By: Robert Triest
Al Vas

Posts: 3
Registered: 3/2/18
Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 29, 2018 6:30 PM
Hi,

I am experienced in Delphi programming but relatively new to database-enabled mobile phone/tablet applications. I am looking to implement a solution that can work when away from mobile network connectivity for entry of information but can then synchronise back to a central database once connectivity is available again. Can anyone point me to a good guide on this, either in book form or by example or even if there is an online training course for this. Any help muchly appreciated.

Regards
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 30, 2018 2:11 AM   in response to: Al Vas in response to: Al Vas
Al Vas

Posts: 3
Registered: 3/2/18
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 30, 2018 4:40 PM   in response to: Robert Triest in response to: Robert Triest

Hi Robert, thanks for your suggestion. Just reading up on database connectivity to mobile apps the general consensus seems to be that a Datasnap server is appropriate but as I understand this does not support TClientDataset. Would that be an accurate assumption?

Regards
Al
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 31, 2018 8:30 AM   in response to: Al Vas in response to: Al Vas
http://docwiki.embarcadero.com/Libraries/Tokyo/en/Datasnap.DBClient.TClientDataSet

"On site, the application uses TClientDataSet to communicate with the database server associated with a source dataset. When a user works off site, the client dataset writes a snapshot of the data to the hard disk. The application works with this snapshot off site, with the client dataset acting as a file-based dataset in a single-tiered application."

Edited by: Robert Triest on Jan 31, 2018 5:30 PM
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 1, 2018 12:00 AM   in response to: Al Vas in response to: Al Vas
Al Vas

Posts: 3
Registered: 3/2/18
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 6, 2018 5:38 PM   in response to: Robert Triest in response to: Robert Triest

Thank you kindly, that has been very helpful.
Al Sme

Posts: 6
Registered: 12/5/16
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 6, 2018 11:08 PM   in response to: Al Vas in response to: Al Vas
Al Vas wrote:

Thank you kindly, that has been very helpful.
Al Vas wrote:

Thank you kindly, that has been very helpful.
Al Vas wrote:

Thank you kindly, that has been very helpful.

I noticed this comment from Embarcadero

Caution: dbExpress, which is described in this tutorial, is being deprecated. This means that dbExpress will be removed from RAD Studio in an upcoming release.
Instead of dbExpress, we recommend that you use our newer database solution, FireDAC

Would it then not be wise to use dbExpress as per the previous link given?
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 7, 2018 12:25 AM   in response to: Al Sme in response to: Al Sme
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Al Sme

Posts: 6
Registered: 12/5/16
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 7, 2018 5:18 PM   in response to: Robert Triest in response to: Robert Triest
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM

Excellent article thanks. I have followed a tutorial for a FireDAC/Datsnap/MSSQL scenario as per the link below. I followed it to the letter, was able to get the server-side working fine but on the client side, although SQLConnection and DSProvider connection is fine, with the final step of setting the ClientDataset component to Active it came up with the following error:

Remote Error: Missing Dataset property.

I can't see where a dataset property would be set so am a little lost at this stage. Would anyone happen to know where I should be looking?
Al Sme

Posts: 6
Registered: 12/5/16
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 7, 2018 6:39 PM   in response to: Al Sme in response to: Al Sme
Al Sme wrote:
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM

Excellent article thanks. I have followed a tutorial for a FireDAC/Datsnap/MSSQL scenario as per the link below. I followed it to the letter, was able to get the server-side working fine but on the client side, although SQLConnection and DSProvider connection is fine, with the final step of setting the ClientDataset component to Active it came up with the following error:

Remote Error: Missing Dataset property.

I can't see where a dataset property would be set so am a little lost at this stage. Would anyone happen to know where I should be looking?

Ok silly mistake, I found it. But now it comes up with a 'SOcket Error #10053 Software caused connection abort'. Probably something else silly but if anyone has a clue in the meantime.....
Al Sme

Posts: 6
Registered: 12/5/16
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 7, 2018 7:34 PM   in response to: Al Sme in response to: Al Sme
Al Sme wrote:
Al Sme wrote:
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM
Robert Triest wrote:
Would it then not be wise to use dbExpress as per the previous link given?
No, (or Yes, not..) but there are more database connection possibilities in Delphi. (Like FireDac and DBGo)

https://ultimatedelphi.wordpress.com/2016/04/14/database-connectivity-frameworks-in-delphi/

Edited by: Robert Triest on Feb 7, 2018 9:27 AM

Excellent article thanks. I have followed a tutorial for a FireDAC/Datsnap/MSSQL scenario as per the link below. I followed it to the letter, was able to get the server-side working fine but on the client side, although SQLConnection and DSProvider connection is fine, with the final step of setting the ClientDataset component to Active it came up with the following error:

Remote Error: Missing Dataset property.

I can't see where a dataset property would be set so am a little lost at this stage. Would anyone happen to know where I should be looking?

Ok silly mistake, I found it. But now it comes up with a 'SOcket Error #10053 Software caused connection abort'. Probably something else silly but if anyone has a clue in the meantime.....

Appears to be some sort of firewall issue. When I disable the firewall it works. Problem is I can't really decipher which ports need to be opened.
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Database Connectivity for Mobile Application
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 8, 2018 12:28 AM   in response to: Al Sme in response to: Al Sme
Appears to be some sort of firewall issue. When I disable the firewall it works. Problem is I can't really decipher which ports need to be opened.
The port of your FireDac server? Mostly in the examples port 8080 is used for testing purposes.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02