Hi,
when I try to connect with sqlalchemy and mssql+pyodbc I get this exeption:
"TypeError: The first argument to execute must be a string or unicode
query".
It works if I only use pyodbc.
E.g.
>>> conn = pyodbc.connect('DRIVER={SQL
Server};Server=127.0.0.1;Database=BOM;UID=guest;PWD=guest')
>>> cursor = conn.cursor()
>>> cursor.execute("select * from Objects")
>>> result = cursor.fetchone()
-> now `result` is a result from the database as it should be.
When I try to connect with sqlalchemy:
>>> engine =
sqlalchemy.create_engine('mssql+pyodbc://guest:[email protected]/BOM')
>>> engine.execute("select * from Objects")
-> The above TypeError exception (complete
traceback: http://pastebin.com/PHxbynFt )
Not sure if this bug is related: http://www.sqlalchemy.org/trac/ticket/2355
Any ideas what could be wrong and how to fix it?
I would really like to stick with python3 ;)
Thanks,
Daniel
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
