[DB-SIG] Sybase module

Harri PASANEN harri.pasanen@trema.com
Fri, 29 May 1998 14:05:07 +0200


I'm having slight problems with Peter Godman's sybase module
on Windows NT, with Sybase server being on Sparc-Solaris 2.6.

The same Python program works every time on Solaris, but
on NT it occasionally hangs, always in the same place on
cursor.execute().  Looks like there is something
locking the cursor, as sp_lock always then gives:

 fid    spid   locktype                     table_id    page       
dbname          class                         
 ------ ------ ---------------------------- ----------- -----------
      0     20 Sh_intent                       16003088           0
fk4_0           Cursor Id 1310912
      0     20 Sh_page                         16003088        6944
fk4_0           Cursor Id 1310912

I only have one python cursor, which I open in the beginning of program
close at the end, so it must be something in the sybase C-api level.

I just wonder if anyone has a clue, before I dive in the sources head
(ActuallyI already took a quick look, but could not really put my 
finger on it... ;-( )