Re: [Python-sybase-misc] Python-Sybase instalation problems

[Michał S. <mi...@sa...>]

Dnia 2011-01-25, wto o godzinie 16:35 -0600, Robert Boehne pisze:
> Great! Let's focus on that.  Below you're letting some of the
> arguments default, like the password and database, but when you use
> pymssql you have explicitly set them. 
> Can you still connect when you use those same arguments with the tsql 
> command line?

It works like so:

> $ tsql -S asademo -U DBA -P SQL
> locale is "pl_PL.UTF-8"
> locale charset is "UTF-8"
> 1>

But not with the database set:

> $ tsql -S asademo -U DBA -P SQL -D asademo
> locale is "pl_PL.UTF-8"
> locale charset is "UTF-8"
> Default database being set to asademo
> Msg 102, Level 15, State 0, Server , Line 0
> ASA Error -131: Syntax error near 'use' on line 1
> There was a problem connecting to the server

I suppose that's correct since AFAIK Sybase only has one database per
server, so no database selection can take place.

The exact same arguments to _mssql.connect():
> conn = _mssql.connect(server='asademo', user='DBA', password='SQL')
> MssqlDriverException: Could not set connection properties

And, as I wrote in the other e-mail, that's probably to be expected with
pymssql trying to connect to (an old) sybase.

Best regards,
-- 
Michał Sawicz <mi...@sa...>