Anywhere16: Connection Limit (Licensed seats) = 3?

[former_member209084]

We are developing a system with Anywhere16 Developer Edition.

When starting up a DB, we saw that connection limit is restricted at 3.

Is this a limit of Developer Edition? We googled but couldn't find any info about the connection limit of Developer Edition.

We got the license key by registering at this site or so:

SAP - Please Register

If we want to carry out load test later, is there any way to raise the limit?

[former_member244518 · Accepted solution]

Hi Henry,

You can use the dblic tool to configure the connection limit to the number of licensed seats that you are entitled to.

For example, to adjust the number of seats to 25, run the following at an elevated command prompt:

"%SQLANY16%\Bin64\dblic.exe" -l perseat -u 25 "%SQLANY16%\Bin64\dbsrv16.lic"

"%SQLANY16%\Bin64\dblic.exe" -l perseat -u 25 "%SQLANY16%\Bin64\dbeng16.lic"

"%SQLANY16%\Bin64\dblic.exe" -l perseat -u 25 "%SQLANY16%\Bin64\mlsrv16.lic"

This document outlines some of the license terms for the Developer Edition. In particular, section 3b describes "test and prototyping use".

You must use this utility only in accordance with your license agreement to license the number of users or processors to which you are entitled. Running this command does not grant you license.

Thanks,

Mikel Rychliski

SAP Active Global Support

[former_member209084 · Accepted solution]

It works! Thanks very much!

The license we have procured (but not yet got in hands) is Workgroup Edition Chip License, which, from what I learned, should have no limit to no. of connections.

[former_member209084]

Screenshot is attached, which show the connection limit is 3.

In general, what determines the connection limit? Edition of Anywhere? License key? A configurable variable?

[Former Member]

Hello Henry,

this doesn't surprise me at all. It is doing exactly "what it says on the tin". We usually use just the personal server on our PCs. The only time I've needed to use the network server is when testing replication, and 3 connections are more than adequate.

If you want to do load testing your can either put the load through the 3 connections (have the database itself spawn queries) or get a full version of the server. To do this you can buy it as normal or maybe talk to someone at SAP (or a 3rd party vendor) about an evaluation.

Plainly, if you've reached the point of doing load testing, your project has already made the decision to use SQL Anywhere*. It's time to add some 'real' copies to the project budget.

Paul

*good pick

[former_member209084]

Thanks for the reply.

In fact we have already procured it. But the procurement procedures of our company takes some time (a few months at least), we haven't got our copies and license keys yet.

Just want to make sure this limit was due to the Developer Edition and Key. In this case, we will contact the local sales of SAP and see if he can arrange some early copies/keys for us to use.