Access a mySQL database from application developed with Delphi XE2

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
LVL 1
LeTayAsked:
Who is Participating?
 
ste5anConnect With a Mentor Senior DeveloperCommented:
The standard ADO components.
0
 
LeTayAuthor Commented:
I was not sure
I will try them
Thanks
0
 
LeTayAuthor Commented:
Where can I find some examples ?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
jimyXCommented:
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
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
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
 
Geert GOracle dbaCommented:
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
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
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
 
LeTayAuthor Commented:
Gonna look at all these suggestions soon !
Holiday for the moment...
0
 
LeTayAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.