[python-sybase] connection exception

[Bradley Feldman]

I was just going to say the same thing.  That's exactly what I do.

-----Original Message-----
From: Chris Curvey [mailto:ccurvey at gmail.com] 
Sent: Tuesday, March 21, 2006 9:01 PM
To: David.Bear at asu.edu
Cc: python-sybase at www.object-craft.com.au
Subject: Re: [python-sybase] connection exception


You're connecting just fine.  Sybase is sending back an error message
telling you what character set and database you are using.  You'll have to
trap for that and just drop the "error"


On 3/21/06, David Bear <David.Bear at asu.edu> wrote: 

I am using freetds instead of sybase to connect to our sybase server.

==========
d = Sybase.connect('ASU_DATA_WAREHOUSE', 'user', 'pw')
Traceback (most recent call last):
  File "<stdin>", line 1, in ? 
  File "/usr/lib64/python2.4/site-packages/Sybase.py", line 1005, in
connect
    strip, auto_commit, delay_connect, locking)
  File "/usr/lib64/python2.4/site-packages/Sybase.py", line 867, in 
__init__
    self.connect()
  File "/usr/lib64/python2.4/site-packages/Sybase.py", line 886, in
connect
    status = conn.ct_connect(self.dsn)
  File "/usr/lib64/python2.4/site-packages/Sybase.py", line 200, in 
_servermsg_cb
    raise DatabaseError(_fmt_server(msg))
Sybase.DatabaseError: Msg 4294973000, Level 10, State 1
Changed client character set setting to 'iso_1'.
Msg 8589940293, Level 10, State 2
Changed database context to 'DICTIONARY'. 
===============

the connection object never gets made. Can anyone shed light on what
this error means? I am able to connect using freetds tsql command.

--
David Bear
phone:  480-965-8257
fax:    480-965-9189 
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
"Beware the IP portfolio, everyone will be suspect of trespassing"
_______________________________________________
Python-sybase mailing list 
Python-sybase at www.object-craft.com.au
https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase
<https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase> 





-- 
Nervous passengers are advised to wear a blindfold. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.object-craft.com.au/pipermail/python-sybase/attachments/20060321/dfa7c4c4/attachment.htm