Re: Large varchar columns with SQL server
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
- Date: Tue, 27 Jun 2006 09:14:05 +0100
brian.lukoff@xxxxxxxxx wrote on 26 Jun 2006 14:04:52 -0700:
Hi everyone,
I'm trying to track down some bugs that I read about at
http://www.aspfaq.com/show.asp?id=2188. I'm connecting to a SQL
database in ASP. Does anyone know specifically what configurations
(e.g., what versions of MDAC, what types of connections, etc.) cause
these bugs to appear? (I'm most concerned about the bugs that cause no
error to display but return no data from the field.)
I've had in the past issues where a server side cursor, returning a row in a
table with a number of text columns, resulted in no data being returned from
those columns if a column to the right of them is read before they are. Also
once you've read the data once, a second read returns an empty value. From
what I remember reading articles about this, a pointer to the text column
data on the server was discarded on the first read, and pointers to the
columns to the left of it discarded too.
Switching to client side cursors, or reading the columns from left to right
and only once, solves this. I don't know if this is still a problem for me
as my code hasn't been changed in a few years and it still works. I had
these issues with SQL Server 7 via ODBC using ADO 2.1 with MDAC 2.1.
The KB article http://support.microsoft.com/default.aspx/kb/175239 (thanks
Stephen, saved me looking it up) mentions that this is fixed in MDAC 2.1 SP2
when using the SQL Server 3.7 driver or higher.
Dan
.
- References:
- Large varchar columns with SQL server
- From: brian . lukoff
- Large varchar columns with SQL server
- Prev by Date: Can't use "FOR XML" query w/ _RecordsetPtr?
- Next by Date: Re: Can't use "FOR XML" query w/ _RecordsetPtr?
- Previous by thread: Re: Large varchar columns with SQL server
- Next by thread: Can't use "FOR XML" query w/ _RecordsetPtr?
- Index(es):
Relevant Pages
|
