Re: Python-Sybase instalation problems

MichaƂ Sawicz <[email protected]> Tue, 25 Jan 2011 23:48:00 +0100
Newsgroups gmane.comp.python.sybase
Message-ID <[email protected]>
--===============3934877978443056553==
Content-Type: multipart/signed; micalg="pgp-sha1";
	protocol="application/pgp-signature";
	boundary="=-zmH/WZ3eBpdLc575BXlF"


--=-zmH/WZ3eBpdLc575BXlF
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.=20
> Can you still connect when you use those same arguments with the tsql=20
> 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 =3D _mssql.connect(server=3D'asademo', user=3D'DBA', password=3D'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,
--=20
Micha=C5=82 Sawicz <[email protected]>

--=-zmH/WZ3eBpdLc575BXlF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)

iEYEABECAAYFAk0/UyAACgkQzQlUjpZYlbcskACeIwSsXZayVU90EccWAy/aDSHC
tW0An3Mj6Hh8FjxevBVj/l3C87KHvk/T
=LM8X
-----END PGP SIGNATURE-----

--=-zmH/WZ3eBpdLc575BXlF--



--===============3934877978443056553==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
--===============3934877978443056553==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Python-sybase-misc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/python-sybase-misc

--===============3934877978443056553==--