Validate MySQL server
Posted: Mon 18 Aug 2008 07:28
I am quite new to this MyDAC and Delphi (am an experience Access db developper) but now I have to write a program that cam convert data from >200 Paradox tables to a MySQL db and found that MyDAC is very good at this - maybe a bit slow in the insert, but that I will have to work on.
What I am looking for is a simple way to test the connection to the MySQL server when my program starts. I don't see any use in trying to insert records if the server is dead or the db is not found.
Any code snippets available out there.
(Please bear with me if this is not the correct place for asking - I just started using this forum)
What I am looking for is a simple way to test the connection to the MySQL server when my program starts. I don't see any use in trying to insert records if the server is dead or the db is not found.
Any code snippets available out there.
(Please bear with me if this is not the correct place for asking - I just started using this forum)