On Jul 9, 2013, at 11:18 AM, Leonid Ilyevsky <lilyev...@gmail.com> wrote:
> I have exact same problem. Any good news on this? > How come it works fine with just pyodbc but not with sqlalchemy? Looks like > alchemy does not pass all parameters down properly. this issue has been resolved, if you must use Python 3 with pyodbc please use 0.9: http://www.sqlalchemy.org/download.html#development > > On Thursday, March 7, 2013 1:58:23 PM UTC-5, Michael Bayer wrote: > 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 <daniel...@gmail.com> 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:guest@127.0.0.1/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 sqlalchemy+...@googlegroups.com. >> To post to this group, send email to sqlal...@googlegroups.com. >> 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 sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.