|
From: hopfgartner <hop...@ro...> - 2002-11-26 06:18:53
|
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
|