How many clients?

forum.sqlbase (1998-2010)

How many clients?

Post by G G » 10 Mar 2009, 17:22

 Posted by:  G G 

Hi to all. How are the connected clients counted? I mean: when connecting to
SqlBase from a SqlWindows application via native client (two times) and from
a VB application via ODBC, how many clients are counted? I am asking this
because on a 5 users SqlBase 8.5 ptf 3 where is running a software made with
SqlW for accountancy and invoicing, is connected, via ODBC, a third party
software made with VB. One of the clients is suddenly disconnected without
any reason. Five PC are using these software, but not simultaneously.
Network problem or user limit reached?



Jim McNamara

How many clients?

Post by Jim McNamara » 10 Mar 2009, 18:34

 Posted by:  Jim McNamara 

Each session is a client. One PC with 3 separate programs is 3 clients. If
users are getting disconnected with no error thrown from the server there
could be a network issue. Exceeding 5 users will not bump a user - it will
refuse to connect (with an appropriate message).


How many clients?

Post by G G » 11 Mar 2009, 10:42

 Posted by:  G G 

Sure? I connected from the same machine with 12 different applications on
the same db, han one another on a different db then 1 time from a different
client and I got 12 connections ona 10 users server. Look at the attachment.
May be users are different machines? I am connected with

Set SqlDatabase=sDatabase
Set SqlUser=sUser
Set SqlPassword=sPassword
If Not SqlConnect( hSqlA )
Return FALSE
Call SqlSetIsolationLevel(hSqlA, 'RL')
Call SqlSetParameter( hSqlA, DBP_PRESERVE, TRUE, '' )
Call SqlSetParameter( hSqlA, DBP_ROLLBACKONTIMEOUT, FALSE, '' )
Call SqlSetLockTimeout( hSqlA, 30 )

Something wrong? I didn't try with ODBC.

Rainer Ebert

How many clients?

Post by Rainer Ebert » 11 Mar 2009, 11:34

 Posted by:  Rainer Ebert 

All native connections from one PC are counted as 1 user. But I'm not sure
about OLEDB and ODBC. Deep in my mind there is something telling me, that
those connections are counted as separate user. But I'm not sure, perhaps
this was with 16 and 32 bit clients in parallel and not with native and O*
in parallel.

Nevertheless if you reach the user limit, you will get an appropriate error
message on SqlConnect(hSql) an no connection is made (this at least for
native connections). If you loose a connection during program runtime, I
don't think this has to do with the user limit.



How many clients?

Post by G G » 11 Mar 2009, 11:41

 Posted by:  G G 

Of course! I am thinking to CONFICKER virus. This was only to be sure about
the count of clients.
Thank to all.

Mike Vandine

How many clients?

Post by Mike Vandine » 12 Mar 2009, 02:23

 Posted by:  Mike Vandine 

For user counts for licensing, think of one PC as being one user. The first
connection from the PC to the server sets a 'flag' that this user is
connected. Additional connections use that 'flag' and are not counted as a
connection for number of users allowed. So you can connect to as many
databases with as many applications as you like from that PC and it will
only count as one users.

Hope this helps.


Return to “forum.sqlbase”

Who is online

Users browsing this forum: No registered users and 0 guests