asked on

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

ASKER CERTIFIED SOLUTION

ste5an

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LeTay

ASKER

I was not sure
I will try them
Thanks

LeTay

ASKER

Where can I find some examples ?

jimyX

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.

Ferruccio Accalai

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

Geert G

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

Ferruccio Accalai

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

LeTay

ASKER

Gonna look at all these suggestions soon !
Holiday for the moment...

LeTay

ASKER

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 !