Michael, Rick,
thank you for your answer.
I use adodbapi, yes sorry for having not given this information.
I debugged into and found that in the very beginning of mssql.py there
is a comment on a non-standard connections string of adodbapi.
So I tried to make a quick hack into default/engine.py and changed some
lines as following:
class PoolConnectionProvider(base.ConnectionProvider):
def __init__(self, dialect, url, poolclass=None, pool=None, **kwargs):
(cargs, cparams) = dialect.create_connect_args(url)
if pool is None:
kwargs.setdefault('echo', False)
kwargs.setdefault('use_threadlocal',True)
if poolclass is None:
poolclass = sqlalchemy.pool.QueuePool
dbapi = dialect.dbapi()
if dbapi is None:
raise exceptions.InvalidRequestError("Cant get DBAPI
module for dialect '%s'" % dialect)
def connect():
try:
# change goes here
return dbapi.connect(dialect.connect_args()[0][0])
# removed return dbapi.connect(*cargs, **cparams)
except Exception, e:
raise exceptions.DBAPIError("Connection failed", e)
self._pool = poolclass(connect, **kwargs)
else:
if isinstance(pool, sqlalchemy.pool.DBProxy):
self._pool = pool.get_pool(*cargs, **cparams)
else:
self._pool = pool
This way it works for me. Sorry that my understanding of SQLAlchemy is
too poor at the moment to provide you a real fix...
Regards,
Thomas
-------------------------------------------------------------------------
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
