Solved

Connection between libmysql.dll and MySQL Versions

Posted on 2016-08-02
7
111 Views
Last Modified: 2016-08-04
My Delphi Application needs to connect to the MySQL database on my WebSite therefore I am forced to package libmysql.dll along with my application. My fear is that if my WebSite person upgrades his version of MySQL then my Delphi applications will stop functioning correctly.
Therefore I wanted to know more about this libmysql.dll. Does it change with every version of MySQL ? Can this Dll be avoided ?
0
Comment
Question by:Allan_Fernandes
  • 3
  • 2
  • 2
7 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41740132
I have 4 versions of MySQL and every one has a different version of 'libmysl.dll'.  Plus a copy of MySQL Tools has a different version.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 41740418
are you sure you can place your own library on the hosted website ?
0
 

Author Comment

by:Allan_Fernandes
ID: 41740704
no no! (My initial question is confusing.)

My application will be running on the Desktop/Laptop's of my customers and the Dll will reside on their respective machines. The MySQL database is hosted on the Website already and I will just use that.

Seems like the only option that I have is to check some predefined text file (via FTP) on my Website and if that text file says  so my application will download new the new Dll's.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 150 total points
ID: 41741863
and i will just use that ...
your application will not be able to connect to the hosted mysql
so technically the customers don't need mysql dll's

unless... something which not all hosting sites allow ...  
https://be.godaddy.com/help/connect-remotely-to-databases-4978

item 6
https://be.godaddy.com/help/create-mysql-or-ms-sql-databases-36

you might also need a dedicated ip:
https://be.godaddy.com/hosting/dedicated-ip

the crappy workaround:
your app places files via ftp on your website
your website checks for those command files, processing and creates output files
your app checks for those output files, via ftp, downloads those files
and displays content on the screen

make sure you can access your mysql directly first
if not, you might have to find a hosting site which does allow this
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 350 total points
ID: 41741870
The way I do this is to have a program (PHP for me) on the web site that accepts requests from the desktop program, queries the database, and returns the info to the desktop.  that avoids the need to keep the MySQL driver up to date.  And it avoids the problem of hosts that don't allow direct external access to the database servers.
0
 

Author Closing Comment

by:Allan_Fernandes
ID: 41742290
Oops why did I not think of the PHP before. Though I am not  a PHP developer I have managed to learn that much of PHP. This will resolve my issue totally.

My Website does allow me to connect directly to the MySQL.

Thanks to both of you for the good advice.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41743070
You're welcome, glad to help.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 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