SQL Anywhere License

[Former Member]

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?

[VolkerBarth]

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')

[Former Member]

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?

[Breck_Carter]

What is the error?

[Former Member]

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"

[VolkerBarth]

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.

[Former Member]

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