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==--