is it sybase doing this

[earlrainer]

Hi

I have this program in delphi which accesses a sybase database.
Now the exe and the database both lie on the server and the users access the program from their machines.
There is no problem if two users are logged in and are using the program at the same time.
However the problem comes up when third user tries to login.
The program on his machine seems to go in a hang mode...and nothing happens for even about half an hour.
However if one of the other user logs out ,then the program on the third users machines starts to work properly.

I am not sure if this is a sybase setting which restricts the number of users accessing the database at the same time

Bye

 

[qyllr]

hello,

try running sp_configure to find out the number of remote connections and the number of remote logins...

the default should be 20 connections...

for troubleshooting...

try running sp_who and validate whether or not the third user is sleeping... this could mean that the third user is able to connect but waits for the first two processes to finish...

it could also be possible that you are experiencing locking problems... you can see this reported on the 'blk' column output of an sp_who...
for locking issues you can also run sp_lock and/or the following sql:

select * from master..syslogshold
go

hth,
q.