[sqlalchemy] sqlalchemy error with XML column type in MS SQL 2005 - TypeError: issubclass() arg 1 must be a class

2011-05-04 Thread Thang Nguyen
Hi, I am running into an error with sqlalchemy when using XML datatype in MSSQL (existing table). My test_table just has two columns: id, test. The test column is xml datatype. Is XML datatype supported? Or is it something I did not do correctly? Thanks for your help in advance. TPN Here is

Re: [sqlalchemy] sqlalchemy error with XML column type in MS SQL 2005 - TypeError: issubclass() arg 1 must be a class

2011-05-04 Thread Thang Nguyen
suggest. thanks much. TPN On Wed, May 4, 2011 at 12:22 PM, Michael Bayer mike...@zzzcomputing.com wrote: it likely an old bug in 0.5 can you try 0.6.7 ?   unknown types should be ignored during reflection. On May 4, 2011, at 3:04 PM, Thang Nguyen wrote: Hi, I am running into an error

Re: [sqlalchemy] datetime is causing error when accesing MSSQL via sqlalchemy - pyodbc/TDS

2011-04-28 Thread Thang Nguyen
=MYUSER;PWD=MYPASS1) cursor = conn.cursor() cursor.execute(select * from test_product) print cursor.fetchone() On Apr 27, 2011, at 8:44 PM, Thang Nguyen wrote: Hi, I am getting an error accessing MSSQL database using sqlalchemy/pyodbc/TDS driver.  After narrowing the case, looks like

[sqlalchemy] datetime is causing error when accesing MSSQL via sqlalchemy - pyodbc/TDS

2011-04-27 Thread Thang Nguyen
Hi, I am getting an error accessing MSSQL database using sqlalchemy/pyodbc/TDS driver. After narrowing the case, looks like it has something to do with datetime datatype. If I deldete the created_at column (datetime) then the same code will work. Any suggestion for further debugging? Thanks in

Re: [sqlalchemy] sqlalchemy with pyodbc - Error: 'pyodbc.Connection' object is not callable

2011-03-23 Thread Thang Nguyen
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

[sqlalchemy] sqlalchemy with pyodbc - Error: 'pyodbc.Connection' object is not callable

2011-03-22 Thread Thang Nguyen
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 =