[Zope] Zope and ZSybaseDA problem

5 Oct 1999

      I have a problem getting ZSybaseDA to work : any connection is rejected with the following error :

Error Type: SybaseError
Error Value: ['failed to connect to server',  ('client', 5, 84083972, 'ct_connect():   network packet layer: internal net library error:   Net-Lib protocol driver call to connect two endpoints failed', 0,   'Socket connect failed - errno 0', 0, '08001')]

The problem appears when :

-- opening the database connection with Zope manager screen
-- executing a minimal external method which uses ctsybase module:

sybtest.py:

import ctsybase
def OpenSybase(self):
    c=ctsybase.ctsybase({'user':'user','password':'password',
                         'server':'server'})
    res=c.execute('select * from table')
    c.close()
    return `res`
if __name__=="__main__": print OpenSybase(None)

But *not* when :

-- executing that same method directly from python
-- executing it from Zope via an external method which does
   a popen of that script
-- executing a popen of one of the sybase ct-lib samples (getsend)

So, it seems the ctsybase module works ok, except when activated from Zope...

My context is:

OS : AIX 4.1.5
Python : 1.5.2
Zope : 2.0.1
ZSybaseDA : tried 0.9 and 1.0.1
Sybase Open-Client : 11.1.1

Any help welcome...

--
Georges JEGO -- Ministère de l'agriculture et de la pêche
251 rue de Vaugirard - 75732 PARIS Cedex 15 - FRANCE
Tél : 01 49 55 86 34 -- Fax : 01 49 55 86 66
Mél : georges.jego@agriculture.gouv.fr