The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

I installed SQL Anywhere years ago and forgot what type of license I am using, so how can I determine how my server or client is licensed. What type of license am I using?

asked 08 Jun '15, 07:36

barhoum99's gravatar image

barhoum99
11222
accept rate: 0%

edited 09 Jun '15, 03:26

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646


You can use the DBLIC tool to check that, such as (here for the network server dbrsv12):

"%SQLANY12%\bin64\dblic" "%SQLANY12%\bin64\dbsrv12.lic"

Furthermore, there a a few server-level properties you can query in DBISQL, such as

select property('LicenseType'), property('LicenseCount')
permanent link

answered 08 Jun '15, 07:47

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
accept rate: 32%

edited 08 Jun '15, 07:51

Thank you for the answer, however, to be more precise I am using the 60 days trial of SQL Anywhere, the problem is on a customer of mine. Thus, after typing "%SQLANY12%\bin64\dblic" "%SQLANY12%\bin64\dbsrv12.lic" , I am getting an error on the trial, should I try this on customer's computer? or should i do something else?

(08 Jun '15, 08:07) barhoum99
Replies hidden

What is the error?

(08 Jun '15, 08:18) Breck Carter

Could not execute statement. Syntax error near '%SQLANY12%\bin64\dblic' on line 1 SQLCODE=-131, ODBC 3 State="42000" Line 1, column 1

"%SQLANY12%\bin64\dblic" "%SQLANY12%\bin64\dbsrv12.lic"

(08 Jun '15, 08:36) barhoum99
Replies hidden

Note, DBLIC is a program, so you have to execute that command line in a CMD shell window, not as a SQL statement (in contrast to the "select property..." sample, which is a SQL statement)...

You need to run that for the database engine you want to check, I can't tell whether that is on your or your customer's box.

(08 Jun '15, 09:26) Volker Barth

Thank you very much for the support, it worked, and if anything goes wrong later on, I will update the post.

(08 Jun '15, 09:57) barhoum99
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:

×405
×48
×4

question asked: 08 Jun '15, 07:36

question was seen: 822 times

last updated: 09 Jun '15, 03:26