what happens if you try your stuff without using freeTDS at all ?
lots of problems are reported with FreeTDS and I had my own negative
experience with it recently.
On Feb 25, 2009, at 5:35 AM, Timothy N. Tsvetkov wrote:
>
> More info: I have MacOSX and use iODBC with FreeTDS driver.
>
> And looks like everything is OK:
>
> FreeTDS:
>
> [tu...@2kan-2:~/bigur]% tsql -S libra -p 1433 -U user
> locale is "ru_RU.KOI8-R/UTF-8/ru_RU.KOI8-R/ru_RU.KOI8-R/ru_RU.KOI8-R/
> ru_RU.KOI8-R"
> locale charset is ""
> Password:
> 1> select * from tax
> 2> go
> <...>
> (4 rows affected)
>
> ODBC:
> iodbctest "DSN=libra;UID=user;PWD=password"
> iODBC Demonstration program
> This program shows an interactive SQL processor
> Driver Manager: 03.52.0406.1211
> Driver: 0.82 (libtdsodbc.so)
>
> SQL>...
>
> And also I tried to connect with pyodbc:
>
> tu...@2kan-2:~/bigur/calculation]% py
> Python 2.5.2 (r252:60911, Feb 23 2009, 21:22:55)
> [GCC 4.0.1 (Apple Inc. build 5488)] on darwin
> Type "help", "copyright", "credits" or "license" for more information.
>
>>>> import pyodbc
>>>> pyodbc.connect("DSN=libra;UID=gik;PWD=123")
> < pyodbc.connection object="object" at="at" 0x57620="0x57620" >
>>>> c = _.cursor()
>>>> c.execute("SELECT * from tax").fetchall()
> <...>
>
> On Feb 24, 9:04 pm, "Timothy N. Tsvetkov" <timothy.tsvet...@gmail.com>
> wrote:
>> Hi all, I'm new to SQLAlchemy, and I've a problem using it.
>>
>> [tu...@2kan-2:~/bigur/calculation]%
>> python
>> Python 2.5.2 (r252:60911, Feb 23 2009, 21:22:55)
>> [GCC 4.0.1 (Apple Inc. build 5488)] on darwin
>> Type "help", "copyright", "credits" or "license" for more
>> information.
>>
>>>>> from sqlalchemy import *
>>>>> db = create_engine('mssql://some_name:some_passwpod@/?
>>>>> dsn=Libra&driver=FreeTDS')
>>>>> metadata = MetaData()
>>>>> metadata.bind = db
>>>>> metadata.bind.echo = True
>>>>> users_table = Table('tax', metadata, autoload=True)
>>
>> 2009-02-24 20:54:55,261 INFO sqlalchemy.engine.base.Engine.0x...2850
>> SELECT user_name() as user_name;
>> 2009-02-24 20:54:55,261 INFO sqlalchemy.engine.base.Engine.0x...2850
>> []
>> 2009-02-24 20:54:55,280 WARNING sqlalchemy.pool.QueuePool.0x...27b0
>> Error closing cursor: Attempt to use a closed cursor.
>> 2009-02-24 20:54:55,280 INFO sqlalchemy.engine.base.Engine.0x...2850
>> ROLLBACK
>> Traceback (most recent call last):
>> File "<stdin>", line 1, in <module>
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/schema.py", line 113,
>> in __call__
>> return type.__call__(self, name, metadata, *args, **kwargs)
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/schema.py", line 241,
>> in __init__
>> _bind_or_error(metadata).reflecttable(self,
>> include_columns=include_columns)
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
>> 1265, in reflecttable
>> self.dialect.reflecttable(conn, table, include_columns)
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/databases/mssql.py",
>> line 1123, in reflecttable
>> current_schema = self.get_default_schema_name(connection)
>> File "<string>", line 1, in <lambda>
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
>> 1894, in decorated
>> connection.info[key] = val = fn(self, connection)
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/databases/mssql.py",
>> line 1070, in get_default_schema_name
>> user_name = connection.scalar(sql.text(query))
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
>> 814, in scalar
>> return self.execute(object, *multiparams, **params).scalar()
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
>> 1676, in scalar
>> self.connection._handle_dbapi_exception(e, None, None,
>> self.cursor, self.context)
>> File "/opt/local/lib/python2.5/site-packages/
>> SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
>> 931, in _handle_dbapi_exception
>> raise exc.DBAPIError.instance(statement, parameters, e,
>> connection_invalidated=is_disconnect)
>> sqlalchemy.exc.ProgrammingError: (ProgrammingError) Attempt to use a
>> closed cursor. None None
>>
>> What I'm doing wrong?
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
