its Python 3 related. that particular ticket refers to how bad of an experience I have when trying to get pyodbc to run well on OSX especially in Python 3. if things have improved, I can try working on it at least in a Linux VM (I still have low hopes for OSX).
On Mar 7, 2013, at 1:41 PM, Daniel Kraus <[email protected]> wrote: > 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. > > -- 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.
