Solved

Access a mySQL database from application developed with Delphi XE2

Posted on 2016-07-16
9
27 Views
Last Modified: 2016-07-22
Currently, I have an application developed with Delphi XE2 that accesses a FireBird database located on my own PC (so working as a Firebird server).
I plan to "migrate" the database to OVH, hosting my domain. Much reliable, secure etc...
The database at OVH is mySQL
So I need to migrate my application as well.
Currently, the application uses Interbase components.
What are the most suitable components to access mySQL from Delphi XE2 ?
Thanks
0
Comment
Question by:LeTay
9 Comments
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 41714514
The standard ADO components.
0
 

Author Comment

by:LeTay
ID: 41714549
I was not sure
I will try them
Thanks
0
 

Author Comment

by:LeTay
ID: 41714551
Where can I find some examples ?
0
 
LVL 24

Expert Comment

by:jimyX
ID: 41715799
Although you got suggestion, but in case you need more. Are you interested in paid component? Try MyDAC expensive but really good one, so many advantages.
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 41717032
You could also use DBExpress components
It's quite easy to use it.
Take a look here for a point of start http://learn-delphi.blogspot.it/2008/06/delphi-dbexpress-and-mysql-part-2.html
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 41720242
your app is a web api dll ?
or a vcl forms exe  ?

if it's not a web api dll, then you'll have to check what's possible

for instance, it's usually not possible to access the mysql from the internet directly
0
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 41720903
I've developed a small db app (vcl form application) using DBExpress and libmysql.dll that point to a linux server using a dyndns.org service to redirect dns to my host and it works like a charm

Here's a screenshot of the TSQLConnection parameters
TSQLConnection parameters
0
 

Author Comment

by:LeTay
ID: 41723735
Gonna look at all these suggestions soon !
Holiday for the moment...
0
 

Author Closing Comment

by:LeTay
ID: 41724402
Finally I will not access such mySQL database because it is hosted by OVH and they do not allow external access to it.
But I appreciate the solution !
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now