yah but we support adodbapi as well, which uses a connection string like "Provider=SQLOLEDB;Data Source=%s;User Id=%s;Password=%s;Initial Catalog=%s".
according to the vague terminology I see at this bizarre website: http://www.connectionstrings.com/ , it seems it might allow this: # Trusted Connection: "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) anyway, as it seems like we dont construct quite that connect string at the moment, you can always use a custom connect function to connect to the engine. the latest SVN supports an easier method for this than that specified in the docs: the "creator" keyword argument (points to a function that opens a new DBAPI connection) sent straight to create_engine: import adodbapi as dbapi def connect(): return dbapi.connect("Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;") e = create_engine('mssql://', creator=connect, module=dbapi) On Sep 4, 2006, at 12:52 PM, Arnar Birgisson wrote: > On 9/4/06, Michael Bayer <[EMAIL PROTECTED]> 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(). > > "integrated authentication" refers to when mssql clients running on > windows use the currently logged in domain user-id and security tokens > to log in to the SQL server - instead of using a user/pass > combination. > > I don't think pymssql supports that at all.. since it's written to be > cross platform. > > Arnar > > ---------------------------------------------------------------------- > --- > 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 ------------------------------------------------------------------------- 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
