Multiple cursors connecting to DB2 via SQLHost

[Alex Polonetskiy]

 Posted by:  Alex Polonetskiy <apol...@csc.com> 

Folks,

I found a difference between the behavior of 16-bit and 32-bit application
connecting to DB2. In 16-bit app, all of the cursors appear to have a single
connection to DB2, therefore if one of them would update a row, it would not
lock the other cursor out.

Since we upgraded to CTD1.5, we had numerous problems with application
locking itself out. Does anyone know of any option in SQL.INI whcih would
ensure the same behaviour as the 16-bit client (ie multiple cursors - one
connection). I know there are options like that for other databases (ie
Sybase), but am not aware of any for SQLHost.

Thanks in advance,
Alex Polonetskiy
apol...@csc.com

[Mike Koshelev]

 Posted by:  Mike Koshelev <Mi...@alekta.sibtrump.ru> 

Alex!
There was message in one of news:


May be this help.
--
Koshelev Mike
Novosibirsk University
mailto: mkos...@chat.ru

[Patricia Warwick]

 Posted by:  Patricia Warwick <pwar...@home.com> 

This is a question for the SQLHost forum!

Actually there should be no difference between the behaviour of cursors
between CTD and SQLWindows, as long as the protocol did not change. If
however, you changed from using a gateway to using direct TCP/IP then
the behavior does change. However the change should not affect cursors
to the same database (service). With the gateway if the userid changed,
it used a different connection, whereas for SQLBase changing the userid
does not force a different connection. A direct TCP/IP connection
behaves like a SQLBase connection so that if you are making subsequent
connections using a different userid, with the gateway it would be a
different connection, but with direct it would not. Now the question is
... are you using a gateway or not? and did this change?

Patricia