sqlite version

[sandy771]

Can unidac return the version of the sqlite dll it is connected to?

or for that matter can it return the version of any driver it is connected to?

[Oma Hans]

For SQLite, simply execute the following query while connected to a data base:

Code: Select all

SELECT sqlite_version();

For PostgreSQL it is

Code: Select all

SELECT version();

Don't know about other engines, but it should be similar.

[AlexP]

Hello,

A version of the server in any provider (SQLite library) can be get using the TUniConnection.ServerVersion property. If a DB client is used for connection, you can find out the client version using the TUniConnection.ClientVersion property.