[python-sybase] Problems invoking stored procedures

[hopfgartner <hop...@ro...>]

Hello,

since we are suning SQL Server 2000 the whole day I'm
working on some tools that should help us to:

1) get quickly all objects as text files in DDL, that can
be processed by CVS

2) export the database schme to DIA.

3) eventually help porting the objects to SQL:1999 or
PostgreSQL

Many things work now, but when I try to run a stored
procedure, sp_helpconstraint, I get a lot of problems.

The system I'm working on is:

Server:
    Windows 2000 SP2
    SQL Server 2000 SP2

Client:
    Debian testing
    Python 2.1.2 and Python 2.3 pre-packages
    sybase-3.6pre1

The problem is included in the 2 attachments. They contain
2 different invokations of the the stored procedure.

The first test gives me:

bonobo@bonobo:~/devel/dbweaver$ python spTest.py
[('DEFAULT on column alrm_time', 'DF_Alarme_Time', '(n/a)',
'(n/a)', '(n/a)', '(n/a)', '(getdate())'), ('PRIMARY KEY
(non-clustered)', 'PK_Alarme', '(n/a)', '(n/a)', '(n/a)',
'(n/a)', 'alrm_id')]
Traceback (most recent call last):
  File "spTest.py", line 8, in ?
    curs.close()
  File "/usr/lib/python2.1/site-packages/Sybase.py", line
350, in close
    self._close()
  File "/usr/lib/python2.1/site-packages/Sybase.py", line
262, in _close
    status = self._cmd.ct_cancel(CS_CANCEL_ALL)
  File "/usr/lib/python2.1/site-packages/Sybase.py", line
145, in _servermsg_cb
    raise DatabaseError(_fmt_server(msg))
Sybase.DatabaseError: State 1, Procedure sp_helpconstraint,
Line 276
 Msg 15470, State 1, Procedure sp_helpconstraint, Line 287
No foreign keys reference this table.

The second gives simply:

bonobo@bonobo:~/devel/dbweaver$ python spTest2.py
Segmentation fault


Could somebody help me?

Thank you very much for your attention.

Peter Hopfgartner