[python-sybase] can't connect to sybase repserver

Daren Wake darenwake at hotmail.com
Mon, 09 Dec 2002 14:03:37 +0000


I'm trying to upgrade from a really old version (0.7) to 2.35.  Mostly it is 
good, but I can no longer connect to a replication server - this should look 
like a normal sybase server

>>>import Sybase
>>>conn=Sybase.connect("REPSERVER", "sa", "xxxx")
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/local/pkgs/python-2.0/lib/python2.0/site-packages/Sybase.py", 
line 670, in connect
    strip, auto_commit, delay_connect)
  File "/usr/local/pkgs/python-2.0/lib/python2.0/site-packages/Sybase.py", 
line 520, in __init__
    self.connect()
  File "/usr/local/pkgs/python-2.0/lib/python2.0/site-packages/Sybase.py", 
line 536, in connect
    self._raise_error(Error, 'ct_options')
  File "/usr/local/pkgs/python-2.0/lib/python2.0/site-packages/Sybase.py", 
line 525, in _raise_error
    raise exc(text)
Sybase.Error: ct_options
Msg 17001, Level 10, State 0:
Line 0:
No SRV_OPTION handler installed.
Layer: 1, Origin: 1
ct_options(): user api layer: external error: An error was returned from the 
server while setting the options, check the server message for details.
>>>


If I comment out the line
status = conn.ct_options(CS_SET, CS_OPT_CHAINXACTS, not self.auto_commit)
in Sybase.py then it will work ok - but presumably this is doing something 
important.

The repserver is version 11.5.1, and I'm using python 2.0 on solaris.

Any help or advice is appreciated.

Thanks,
Daren.



_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail