We simply create a stored procedure named DB_VERSION which returns a
single VARCHAR which is the database version, like '1.46'. Immediately
after connecting to the database the application executes DB_VERSION
and compares it to the application's internal version identifier. If
they match the it proceeds. If not it halts.

Simple but effective.