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.
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<javascript:>>
> 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 <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com<javascript:>
> .
> 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.
