I understand the default connections in SQL ANYWHERE 9 is 5
, how do I set the MAX CONN to 0 which means unlimited
connections.

Recently the DB in our office crashes so we reinstalled Sql
Anywhere but realized now the 6th user is being kicked out.

Please help.Thankyou in advance.

The MAXCONN option only applies to HTTP and HTTPS protocol. If you are using the personal database
server (dbeng9), then the default limit is 5. If you are using the database server for multiple
application connections, you really should be using the network server (dbsrv9) as it is limited
based on you licensing. Are you sure your database server is properly licensed?

To set MAXCONN:

dbeng9 -x http(MAXCONN=10) ...

To check licensing information run:

dblic %ASANY9%\win32\dbeng9
OR
dblic %ASANY9%\win32\dbsrv9

--
Joshua Savill
Sybase Inc. - Product Manager


RISI wrote:

DO I set under the configuration tab in the properties

-c 256M
-x (MAXCONN=10)
tcpip{MYIP=192.168.51.13;DOBROADCAST=No;ServerPort =1498}
-n cornerst d:\data\9_0_2\Cornerst.db

RISI,

The MAXCONN option is only for HTTP and HTTPS protocols. You are using TCPIP according to your
database server command line below.

I suspect your database server is only licensed for 5 users.

Run dblic %ASANY9%\win32\dbeng9 OR dblic %ASANY9%\win32\dbsrv9 to determine how the database server
is licensed. If the database server is licensed incorrectly, use dblic to set the license to the
proper number of users:
http://www.ianywhere.com/developer/p...9/00000594.htm

The proper usage for HTTP:

-c 256M
-x http{MYIP=192.168.51.13;DOBROADCAST=No;ServerPort= 1498;MAXCONN=10}
-n cornerst d:\data\9_0_2\Cornerst.db

--
Joshua Savill
Sybase Inc. - Product Manager


RISI wrote:

Correction: Josh's example mixes up TCPIP and HTTP parameters. The -x
switch is only used for "standard" connections (i.e. dblib, odbc, etc.)
and supports shmem and tcpip. The -xs switch is for web connections and
supports http and https. The proper usage for HTTP would be:

-xs http(MyIP=192.168.51.13;ServerPort=80;MaxConn=10)

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Josh Savill [Sybase] wrote:

Good catch Graeme. The s wandered away from my command line.

--
Joshua Savill
Sybase Inc. - Product Manager


Graeme Perrow [Sybase iAnywhere] wrote: