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

asked 14 Aug '13, 05:54

dilip%20sg's gravatar image

dilip sg
46113
accept rate: 0%

edited 14 Aug '13, 07:25

Volker%20Barth's gravatar image

Volker Barth
30.0k294447654


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.

permanent link

answered 14 Aug '13, 06:50

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334481
accept rate: 12%

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');
(14 Aug '13, 07:24) Volker Barth

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

permanent link

answered 14 Aug '13, 08:18

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 30%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×50
×31
×16

question asked: 14 Aug '13, 05:54

question was seen: 1,043 times

last updated: 14 Aug '13, 08:18