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

2011-01-04 Thread Halgrim, Scott
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

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

2011-01-03 Thread Vernon Cole
#x27;, u'infitrating ductal carcinoma', u'C0007124') > > >>> c.close() > > >>> conn.close() > > adodbapi Closed connection at 1347FD0 > > > > Thanks again, > > > > Scott > > > --

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

2011-01-03 Thread 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 varch

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

2011-01-03 Thread Halgrim, Scott
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

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

2010-12-30 Thread Vernon Cole
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