Hi Everybody,
Crossposting this from the pyodbc ML, in the hopes that someone here has run
into this.. Are there any SQLA unit tests that exercise multiple DB
connections over unixODBC?
Hi all,
Having trouble getting multiple MSSQL connections to work with unixODBC on
CentOS. Confirmed that isql and a single pyodbc connection works fine,
but 2nd connection fails as follows:
>>> import pyodbc
>>> pyodbc.pooling = False
>>> cs = 'DRIVER={FreeTDS}; SERVER=server; UID=user; PWD=pwd; DATABASE=db'
# note that DSN connections fail the same way
>>> c1 = pyodbc.connect(cs)
>>> c2 = pyodbc.connect(cs)
>>> cur1 = c1.cursor()
>>> cur2 = c2.cursor()
>>> cur1.execute("select * from table")
<pyodbc.Cursor object at 0x98339c0>
>>> cur2.execute("select * from table")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
pyodbc.Error: ('IM001', '[IM001] [unixODBC][Driver Manager]Driver does
not support this function (0) (SQLColAttribute)')
Has anybody seen this?
Thanks,
Rick
Richard A. Morrison
Driveazon
38 Washington Square
Newport, RI 02840-2946
V: (203) 254-2054 F:(203) 220-2255
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@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.
