The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
29.3k287438644


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.1k324278
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:

×48
×31
×16

question asked: 14 Aug '13, 05:54

question was seen: 985 times

last updated: 14 Aug '13, 08:18