Subject: Re: [python-win32] adodbapi returns None for text field in first row
Scott:
Thanks! Exactly the kind of detective work needed. There has been suspicion
of a problem with large binary fields, but your example is the first to nail it
down. I suspect that the reported "internal size&quo
#x27;, u'infitrating ductal carcinoma', u'C0007124')
>
> >>> c.close()
>
> >>> conn.close()
>
> adodbapi Closed connection at 1347FD0
>
>
>
> Thanks again,
>
>
>
> Scott
>
>
> --
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 varch
conn.close()
adodbapi Closed connection at 1347FD0
Thanks again,
Scott
From: Vernon Cole [mailto:vernondc...@gmail.com]
Sent: Thursday, December 30, 2010 9:58 PM
To: Halgrim, Scott
Cc: python-win32@python.org
Subject: Re: [python-win32] adodbapi returns None for te
Scott:
Something is indeed fishy. What os, version of python, and version of
pywin32 are you using?
As an attempt to duplicate your result, I built a table "tblTemp" on my
Windows Vista laptop's SQL express 2008 with three VarChar fields
and loaded two rows of data. I defined an ODBC DSN to poin
Has anybody ever had an issue like this?
I submit a query to a table and everything works out fine, except for one
column in one row. The column of type text in the first row returned is always
None. I've modified the query by adding a WHERE clause so that a different row
was the first one re
