[python-win32] adodbapi returns None for text field in first row

[Tim Roberts]

Halgrim, Scott wrote:
>
> Thanks, Vernon.
>
>  
>
> I am using Windows XP, Python 2.7, and adodbapi version 2.2.6 from
> pywin32 v214.
>
>  
>
> The difference between what I’m running and your attempt at
> replication is that the problem is occurring with a column of type
> text, not of type varchar.  (In fact, I’ve currently created a
> workaround to the problem by creating a duplicate table where the
> column is varchar(8000).)
>

You're using Microsoft SQL Server, right?  It may be a problem that you
have a column with the same name as a reserved word.  If you're in SQL
Server 2005 or above, "TEXT" is no longer recommended as a data type. 
You're supposed to use VARCHAR(MAX).

-- 
Tim Roberts, timr at probo.com
Providenza & Boekelheide, Inc.