thanks Michael. It works nicely.
TPN
On Tue, Mar 22, 2011 at 8:53 PM, Michael Bayer <mike...@zzzcomputing.com> wrote:
>
> On Mar 22, 2011, at 10:12 PM, Thang Nguyen wrote:
>
>> Hi,
>>
>> I tried to use sqlalchemy (linux) to connect to MS SQL server
>> (Windows) via ODBC (pyodbc). I got the errors below, just wonder if
>> something was not done correctly. Please shed a light, and thanks in
>> advance.
>>
>> TPN
>>
>>
>> import pyodbc
>> import sqlalchemy
>> from sqlalchemy import *
>> pycon =
>> pyodbc.connect("DRIVER={FreeTDS};SERVER=testserver;DATABASE=TEST_UDC;PORT=1435;UID=Test_Foo;PWD=Test_Foo1")
>> cursor = pycon.cursor()
>> cursor.execute("select * from test_product")
>> rows = cursor.fetchall()
>> for row in rows:
>> print row
>>
>> # up to this point, it works nicely, each row is printed correctly.
>>
>> engine = create_engine('mssql://', creator=pycon)
>> metadata = MetaData(bind=engine)
>> result = engine.execute("select * from test_product")
>> # it fails here
>
> creator needs to be a function:
>
> def pycon():
> return pyodbc.connect(...)
>
> create_engine(...., creator=pycon)
>
>
>>
>> --- Here is the error message --
>> ....
>> ....
>>
>> return _ConnectionRecord(self)
>> File "/xyz/sqlalchemy/pool.py", line 198, in __init__
>> self.connection = self.__connect()
>> File "/xyz/sqlalchemy/pool.py", line 261, in __connect
>> connection = self.__pool._creator()
>> TypeError: 'pyodbc.Connection' object is not callable
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "sqlalchemy" group.
>> To post to this group, send email to sqlalchemy@googlegroups.com.
>> To unsubscribe from this group, send email to
>> sqlalchemy+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/sqlalchemy?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
