Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: Cross platform to connect to MYSQL server.


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 4 - Last Post: Dec 15, 2014 9:40 AM Last Post By: quinn wildman
Stev Warby

Posts: 50
Registered: 10/19/14
Cross platform to connect to MYSQL server.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 11, 2014 2:11 AM
I have been following this link :
docs.embarcadero.com/products/rad_studio...ile_Tutorials_en.pdf

I can compile a windows 32
Mac I get :
The required attribute "Include" is missing from element <ProfileInclude>. C:\Users\stevew\AppData\Roaming\Embarcadero\BDS\15.0\MacOSX10.10.sdk

On IOS I get:

[DCC Fatal Error] Unit2.pas(10): F1026 File not found: 'C:\Users\stevew\Documents\Embarcadero\Studio\Projects\New folder (5)\FireDAC.Phys.MySQL.dcu'

On Android I get:

[DCC Fatal Error] Unit2.pas(10): F1026 File not found: 'C:\Users\stevew\Documents\Embarcadero\Studio\Projects\New folder (5)\FireDAC.Phys.MySQL.dcu'

What am I doing wrong.

Is there a simple cross platform sample to connect to MYSQL Server?
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Cross platform to connect to MYSQL server.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 11, 2014 11:24 AM   in response to: Stev Warby in response to: Stev Warby
The root problem here is that Microsoft does not make a client on
platforms other than Windows. So, to get MSSQL connectivity on non
Windows platforms you need a middle tier, which is DataSnap. Your
application connects to a DataSnap server that you create and runs on a
Windows OS. Your Datasnap server connects to the database.

If you want a database on mobile that does require a middle tier, then
you need to use either SQLite or IBLite/IBToGo (aka InterBase).

Stev Warby wrote:
What am I doing wrong.

Is there a simple cross platform sample to connect to MYSQL Server?
Ste War

Posts: 31
Registered: 1/9/15
Re: Cross platform to connect to MYSQL server.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 11, 2014 4:37 PM   in response to: quinn wildman in response to: quinn wildman
quinn wildman wrote:
The root problem here is that Microsoft does not make a client on
platforms other than Windows. So, to get MSSQL connectivity on non
Windows platforms you need a middle tier, which is DataSnap. Your
application connects to a DataSnap server that you create and runs on a
Windows OS. Your Datasnap server connects to the database.

If you want a database on mobile that does require a middle tier, then
you need to use either SQLite or IBLite/IBToGo (aka InterBase).

Stev Warby wrote:
What am I doing wrong.

Is there a simple cross platform sample to connect to MYSQL Server?

Hi Quinn,

I am talking about MYSQL not MSSQL.
I am using APPMethod and not Delphi XE.
This is what I am trying to achieve.

An RFID inventory program on mobile Android & IOS.

Because the devices will not always have a signal I want to be able to do :

1. Sync to the MYSQL remote tables and download all customer details etc etc.
2. Store the data in a local database file on the device.
3. Add some RFID scans to the local database.
4. When the device has signal sync the data back to the MYSQL server.

I know I can call a php file to get the data but in the past I have used Phonegap and the performance is not great. Using delphi is very quick.

If the above cannot be done and I go down the DataSnap server route can the server program run on a Mac machine.

Is datasnap server included in appmethod ?

Thanks.
Douglas Rudd

Posts: 314
Registered: 5/16/97
Re: Cross platform to connect to MYSQL server.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 12, 2014 8:11 AM   in response to: Ste War in response to: Ste War
Unidac from Devart has components that connect directly to MySQL server. It works on all four Delphi platforms, including IOS and Android. Its been out for a few years. I tried it and it worked great. You can connect directly to your web hosted MySQL server from your phone. I don't know why FireDAC doesn't have this.
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Cross platform to connect to MYSQL server.  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 15, 2014 9:40 AM   in response to: Ste War in response to: Ste War
You should be able to do what you want with DataSnap here, but you
cannot create DataSnap servers with AppMethod. To create a DataSnap
server you need RAD Studio. Another solution here would be to go with
Enterprise Mobility Services. See
http://www.appmethod.com/mobile-enterprise for details.

Note that while not required, you are encouraged to use
community.embarcadero.com for AppMethod questions.

Ste War wrote:
If the above cannot be done and I go down the DataSnap server route can the server program run on a Mac machine.

Is datasnap server included in appmethod ?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02