RE: [python-sybase] python-sybase + FreeTDS + MS SQL Server

[Charles B. <Cha...@ut...>]

> -----Original Message-----
> From: Kevin Jacobs [mailto:ja...@th...]
> Sent: Monday, August 02, 2004 5:07 PM
>=20
> Charles Bearden wrote:
>=20
> >My question is how to supply authentication credentials to the MS SQL
> >Server.  I have to use a domain login userid like DOMAIN\username.
When
> >I create a Python script like this:
> >
> >------------------------------------------------------------
> >import Sybase
> >
> >dsn =3D 'theDb'
> >uid =3D 'MYDOMAIN\jrandomuser'
> >pwd =3D 'h4x0r'
> >cx =3D Sybase.connect(dsn, uid, pwd)
> >
> >cx.close()
> >------------------------------------------------------------
> >
> >
> >
> Try: uid =3D 'MYDOMAIN\\jrandomuser'
>=20
> Don't forget Python's string quoting rules!  ;)


Thanks for your response.  I should have mentioned that I had already
tried several permutations of quoting, including raw strings and the
escaped backslash you recommended.  Still no joy: the "Login failed for
user '(null)'" exception is still thrown.  And when I catch that
exception to print 'uid' before re-raising the exception, it prints the
UID correctly, with the single backslash between domain and username
(and it does so whether or not I've escaped the backslash).

The UID and password I am actually using are my personal domain
credentials that I type in every day to log on.  I'm puzzled by the
'(null)' user thing.  Does that mean that the string I am passing as UID
is not getting through, or that it is not recognized?

Thanks,

Chuck Bearden
Systems Analyst III
School of Health Information Sciences
University of Texas at Houston
713.500.3954 (voice)
713.500.3907 (fax)
Cha...@ut...