You can override that with an environment variable -- see http://www.freetds.org/userguide/envvar.htm for the details.
There are also date translation issues when using Freetds against SQL server; you may need to build it from source to get things to work right. There's an earlier thread in the SA archives about this, IIRC.
Rick
On 6/2/06, mike <
[EMAIL PROTECTED]> wrote:
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
_______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
