hello all -
with an mssql database, i'm walking through this tutorial: http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html when using a connect url that does not include the port, freetds apparently tries to connect to port 4000 by default - i get an error that includes this line: src/tds/login.c: tds_connect: 192.168.100.10:4000: Connection refused but if i specify the port, i get an error that indicates pymssql' connect() doesn't accept a port as a parameter: 'mssql://user:[EMAIL PROTECTED]:1443/db' gives me this error: File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/default.py", line 29, in <lambda> self._pool = poolclass(lambda: dbapi.connect(*cargs, **cparams), **kwargs) TypeError: connect() got an unexpected keyword argument 'port' any suggestions? here's the traceback: Traceback (most recent call last): File "./firststeps.py", line 27, in ? users.create() File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 221, in create File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 395, in create File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 415, in _run_visitor File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 475, in contextual_connect File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 177, in __init__ File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 493, in raw_connection File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/default.py", line 36, in get_connection return self._pool.connect() File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 84, in connect File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 130, in __init__ File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 102, in get File "build/bdist.linux-i686/egg/sqlalchemy/pool.py", line 229, in do_get File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/default.py", line 29, in <lambda> self._pool = poolclass(lambda: dbapi.connect(*cargs, **cparams), **kwargs) TypeError: connect() got an unexpected keyword argument 'port' _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
