Sample Header Ad - 728x90

SQL Anywhere 17 - Database server connection limit exceeded

0 votes
1 answer
2540 views
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
@@max_connections
and got 32'766. Also when I execute the folowing statement I get the following result:
SQL
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?
Asked by Janik Spies (103 rep)
Mar 17, 2021, 02:25 PM
Last activity: Mar 18, 2021, 12:04 PM