Hi,
Does anyone try to use SA with mx.ODBC? I made some attempts but I
failed and I don't know if I'm doing something wrong or it just doesn't
work together?
I copy-pasted databases/sqlite to use mx.ODBC.Windows module and cut
almost everything to check if at least the connection works. I fail on a
simple sequence:
-----------
db = create_engine('odbc', opts={'dsn': 'mydns'})
db.echo = True
l_ki = Table('mytable', db,
Column('indeks', String, primary_key=True),
Column('nazwa', String(40)),
)
s = l_ki.select()
rs = s.execute()
print rs.fetchall()
-----------
I get an error on the last line with:
File "C:\Praca\sqlalchemy\svn_modyfikowane\lib\sqlalchemy\engine.py",
line 845, in fetchone
row = self.cursor.fetchone()
mx.ODBC.Error.InterfaceError: ('HY010', 0, '[Microsoft][Mened\xbfer
sterownik\xf3w ODBC] B\xb3\xb9d sekwencji funkcji', 4438) (Function
sequence error)
>Exit code: 1
I modified pool.CursorFairy.__getattr__ to print all keys and everything
looks fine. The same sequence of cursor operations works outside SA.
Is it possible that it has anything to do with threading? I checked 2
different ODBC adapters. OpenLink fails but Postgresql ODBC works.
Pawel
-------------------------------------------------------
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
