Connection between libmysql.dll and MySQL Versions

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 ?
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
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.
Dave BaldwinFixer of ProblemsCommented:
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.
Geert GOracle dbaCommented:
are you sure you can place your own library on the hosted website ?
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Allan_FernandesAuthor Commented:
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.
Geert GConnect With a Mentor Oracle dbaCommented:
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 ...

item 6

you might also need a 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
Allan_FernandesAuthor Commented:
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.
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
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.