Never mind, I figured it out. On Tuesday, July 9, 2013 1:07:29 PM UTC-4, Leonid Ilyevsky wrote: > > Thanks Michael, this solved the connection problem. > > Could you give me another tip? Now I am trying to get my Table() > definition right, so the select statement will be a correct one. > For mssql, it must be something like: > > select a, b, c from mydb.dbo.mytable > > I just tried to play with it, and I specified table name as the first > argument in Table(), and I got: > > select "mytable"."a", "mytable"."b", "mytable"."c" from "mytable" > > which obviously is not going to work. > > Where do I put the database name? The "dbo" schema? > > Thanks, > > Leonid > > On Tuesday, July 9, 2013 11:34:56 AM UTC-4, Michael Bayer wrote: >> >> >> On Jul 9, 2013, at 11:18 AM, Leonid Ilyevsky <[email protected]> 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 <[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. >> 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. For more options, visit https://groups.google.com/groups/opt_out.
