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

[Charles Bearden]

> -----Original Message-----
> From: Chris Curvey [mailto:ccurvey@earthlink.net]
> Sent: Tuesday, August 03, 2004 9:31 AM
>=20
> -----Original Message-----
> From: Charles Bearden <Charles.F.Bearden@uth.tmc.edu>
> Sent: Aug 3, 2004 10:22 AM
>=20
> > -----Original Message-----
> > From: Kevin Jacobs [mailto:jacobs@theopalgroup.com]
> > Sent: Monday, August 02, 2004 5:07 PM
> >
> > Charles Bearden wrote:
> >
> > >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'
> >
> > Don't forget Python's string quoting rules!  ;)
>=20
>=20
> 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).
>=20
> 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?
>=20
>=20
> Are your user accounts on the SQL Server using the integrated NT login
for
> authentication, or are they using a separate password?  I don't know
for
> sure, but I'd wonder if FreeTDS supported the integrated login scheme.

Thanks for the suggestion--I'll check that out.  I'm a Linux exile in
Windows-land here, except that I'm trying to get this Linux host to talk
to MS SQL, and I am the first to admit that there is a great deal I
don't know about Windows authentication.

Chuck Bearden
Systems Analyst III
School of Health Information Sciences
University of Texas at Houston
713.500.3954 (voice)
713.500.3907 (fax)
Charles.F.Bearden@uth.tmc.edu