Determing SQL Anywhere edition

[Former Member]

Hi,

Currently we are using Sybase SQL Anywhere version 8. However we are not sure which edition (OEM, Workgroup, Standard or Advanced) of SQL Anywhere is used. Is there a way to determine the SQL Anywhere edition?

Any help is much appreciated

Thanks, dilip sg

[reimer_pods]

IIRC the editions Workgroup, Standard, Advanced were introduced with SQL Anywhere 11. Starting with that version, you may retrvieve the server edition with

select Property ('ServerEdition')

How to check for an OEM version I can't seem to find.

[VolkerBarth]

The different editions have been introduced with 11.0.1, to be precise, so with SQL Anywhere 8, there's no such distinction (except for the OEM edition).

Querying the "ServerEdition" property on older versions will return NULL.

AFAIK, older OEM versions should reveal themselves within the starting messages in the console log. I do not know whether they show different values for the following properties in contrast to non-OEM editions:

select property('ProductName') || ' - ' || property('ProductVersion');

[Former Member]

If you open a command prompt in win32 (where dbsrv8 is located) you should be able to determine the edition by running: dblic dbsrv8.exe