Michael Bayer wrote:
> since I dont know what that is, all I can say is the underlying DBAPI
> has to support this form of authentication for this to be possible. and
> i would think that if the DBAPI can do it, it would only be a matter of
> the proper arguments being sent to its connect() method, in which case
> SA supports sending any arguments you want to connect().
If you use integrated authentication, you don't specify a login for
MSSQL. Instead the current windows user is used to login to the sql server.
I had a look at mssql.py in the database folder of SA and at the
underlying DBAPIs. It looks like pymssql does not support integrated
authentication, which makes sense, because it runs also on non windows
plattforms.
Using adodbapi one would simply have to use another connection string in
the case that no user is given. make_connection_string would have to
look like this:
if not "user" in keys:
[["Provider=SQLOLEDB;Data Source=%s;Initial Catalog=%s;
Integrated Security=SSPI;" % (keys["host"], keys["database"])], {}]
else:
[["Provider=SQLOLEDB;Data Source=%s;User Id=%s;Password=%s;
Initial Catalog=%s" % (keys["host"], keys["user"], keys["password"],
keys["database"])], {}]
Would you accept a patch for this?
regards,
Achim
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
