Re: 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 <[email protected]> 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
> [email protected]
> https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase
>



--
Nervous passengers are advised to wear a blindfold.

_______________________________________________
Python-sybase mailing list
[email protected]
https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase