SQL Anywhere 17 – Database Server Connection Limit Exceeded

sap-sql-anywhere-16sybasesybase-sql-anywhere

I set up a new SQL Anywhere 17 Database in Sybase Server. I've got a lot of clients that should be able to connect to the Database over ODBC. The ODBC works fine but as soon as the third user tries to connect i get the following message:

enter image description here

I've tried select @@max_connections and got 32'766.
Also when I execute the folowing statement I get the following result:

SELECT 
PROPERTY('ServerEdition') as ServerEdition, 
PROPERTY('IsNetworkServer') as IsNetworkServer, 
PROPERTY('LicenseType') as LicenseType, 
PROPERTY('LicenseCount') as LicenseCount, 
PROPERTY('MaxConnections') as MaxConnections 
FROM dummy

enter image description here

Does anyone have any idea what I can cause this problem?

Best Answer

You need to use the dblic.exe utility to apply your licence key to the dbsrv17.lic file. See the docs for details.

Max connections is nothing to do with how your server is licenced. You could in theory set up thousands of connections from one network location, and that would use one licence - you want connections from lots of different network seats, so you need more licences. Alternatively you can buy a core based licence.

Related Question