Solved

Access a mySQL database from application developed with Delphi XE2

Posted on 2016-07-16
9
31 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 34

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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
 
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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 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