Increasing the number of user connections

manngupta · #1 (**permalink**) 04-01-08, 13:37

Hi,

Can anyone let me know how to increase the maximum number user connections in Sybase. I tried the command sp_configure "number of user connections", 30 but it is giving an error that the maximum number of connections can't be greater than 25.

Thanks

pdreyer · #2 (**permalink**) 04-02-08, 04:08

What version? I think the developer edition is limited.

manngupta · #3 (**permalink**) 04-02-08, 05:02

The version is Adaptive Server Enterprise 12.5.4 on SUSE 10

Quote:

Originally Posted by pdreyer

What version? I think the developer edition is limited.

apachejrs · #4 (**permalink**) 04-02-08, 23:21

have you tried:

sp_configure 'user connections', <value>

manngupta · #5 (**permalink**) 04-03-08, 03:50

Yes I have tried it but it is giving an error that the number of connections cannot be greater than 25.

Quote:

Originally Posted by apachejrs

have you tried:

sp_configure 'user connections', <value>

pdreyer · #6 (**permalink**) 04-04-08, 07:43

A client-side issue?

Quote:

by default open client limits the
number of connections on the client side to 25. This can be changed
via a ct_config() call:

num = MAX_CONNECT;
retcode = ct_config(context, CS_SET, CS_MAX_CONNECT, &num,
CS_UNUSED, NULL);