Hi,

What defines the TMySQL-connection-version ? Are those the installed libraries on the client ? Or is it the server ?

Is it possible to detect which version of MySQL/MariaDB is used , and according to the result select the right connection, at run-time ?

The problem is that my development-PC does not neccessarily have the same libraties as the user-PC.

FWIW, I'm running linux on the development-PC.

Regards,

Koenraad.

Is it possible to detect which version of MySQL/MariaDB is used , and according to the result select the right connection, at run-time ?

Trial and error:
Loop over the connection component until you find one that doesn't raise exception when activated. Simple, but takes more resource.

Querying the tool:
Executes `mysql --version` and parse the result. Apparently the output is consistent enough between versions, it's always the fifth column. More complicated logic, but lower resource usage.

Let the user decide:
Provide a config file and let user fill it. Just connect anyway to whatever value supplied by user, certainly you can limit to certain accepted values only. This lifts the responsibility to user to supply the correct version.

Load the mysql library manually and check the version returned by

function mysql_get_client_version:culong;

By far the easiest, I would imagine ?

Michael.