Re: How does one determine which underlying database engine is in use?
Vernon Cole wrote:
> When one is using a generic database access tool, such as ADO or ODBC, it is
> possible that the programmer does not know in advance what database engine
> will eventually be used.
> Since different engines have vastly different requirements  it would be
> nice for the programmer to be able to determine which database engine his
> user has handed him.
> Is there any sort of standard or usual way that information may be
> obtained? (If egenix has an extension for this I will happily adopt it.)
We use the connection attributes .dbms_name and .dbms_version for
this in mxODBC and mxODBC Connect:
>  for example, do I use TOP or LIMIT to restrict the number of rows in a
> result set?
The database engine version is usually more interesting than the
engine name (which is typically fixed for an application). With the
version you can easily determine whether advanced SQL features are
available or not.