rev 1870 contains a small fix that should address this.
On Sep 17, 2006, at 12:56 PM, Achim Domma wrote:
> Hi,
>
> I'm using the current svn version of SA and try to connect to a MSSQL
> Server like this:
>
> def connectSqlServer(server,database):
> import adodbapi as dbapi
> def connect():
> return dbapi.connect("Provider=sqloledb;Data Source=%
> s;Initial
> Catalog=%s;Integrated Security=SSPI;" %
> (server,database) )
> return create_engine('mssql://', creator=connect, module=dbapi)
>
>
> meta.connect(
> connectSqlServer(server,database)
> )
>
>
> Here is the traceback I get from within Pylons:
>
> File
> 'C:\\develop\\JustForFun\\pylons_test\\logView\\logview\\lib\
> \base.py',
> line 15 in connectSqlServer
> e = create_engine('mssql://', creator=connect, module=dbapi)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\engine\
> \__init__.py',
> line 92 in create_engine
> return strategy.create(*args, **kwargs)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\engine\
> \strategies.py',
> line 39 in create
> provider = self.get_pool_provider(dialect, u, **poolargs)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\engine\
> \strategies.py',
> line 67 in get_pool_provider
> return threadlocal.TLocalConnectionProvider(dialect, url,
> **poolargs)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\engine\
> \default.py',
> line 18 in __init__
> (cargs, cparams) = dialect.create_connect_args(url)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\databases
> \\mssql.py',
> line 249 in create_connect_args
> return make_connect_string(opts)
> File
> 'c:\\develop\\justforfun\\sqlalchemy_svn\\lib\\sqlalchemy\\databases
> \\mssql.py',
> line 51 in <lambda>
> make_connect_string = lambda keys: \
> exceptions.KeyError: 'host'
>
> What am I doing wrong? As far as I understand, host should not be
> required if I pass a creator!?
>
> 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
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
