what DBAPI are you using with MS-SQL, apparently the module supports
two (i have the dblib-based one)....apparently yours doesnt like
"host" as a keyword argument. if we can figure out exactly what it
wants to connect then the ms-sql connect routine can be adjusted
accordingly...
On Aug 10, 2006, at 11:30 AM, Thomas Handler wrote:
> I'm using one of the latest versions out of svn and have troubles with
> connecting to an MS SQL Server 2000 instance.
>
> What I typed into the interpreter:
>
>>>> db = create_engine('mssql://Testuser:[EMAIL PROTECTED]/TestDb')
>>>> c = db.connect()
>
> What came back:
>
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> File "sqlalchemy\engine\base.py", line 474, in connect
> return Connection(self, **kwargs)
> File "sqlalchemy\engine\base.py", line 177, in __init__
> self.__connection = connection or engine.raw_connection()
> File "sqlalchemy\engine\base.py", line 497, in raw_connection
> return self.connection_provider.get_connection()
> File "sqlalchemy\engine\default.py", line 39, in get_connection
> return self._pool.connect()
> File "sqlalchemy\pool.py", line 85, in connect
> return ConnectionFairy(self).checkout()
> File "sqlalchemy\pool.py", line 141, in __init__
> self.connection = pool.get()
> File "sqlalchemy\pool.py", line 110, in get
> return self.do_get()
> File "sqlalchemy\pool.py", line 249, in do_get
> return self._creator()
> File "sqlalchemy\engine\default.py", line 31, in connect
> raise exceptions.DBAPIError("Connection failed", e)
> sqlalchemy.exceptions.DBAPIError: (Connection failed) (TypeError)
> connect() got
> an unexpected keyword argument 'host'
>
>
>
> Digging into the sources and doing some debugging I saw that the
> URI is
> properly parsed and extracted.
>
> Any hints?
>
>
> Best 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
-------------------------------------------------------------------------
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
