freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Function sequence error from Linux => SQL Server 2000
- From: "James K. Lowden" <jklowden AT schemamania.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Function sequence error from Linux => SQL Server 2000
- Date: Thu, 29 Apr 2004 00:25:23 -0400
On Wed, 28 Apr 2004, "James K. Lowden" <jklowden AT schemamania.org> wrote:
>
> The other possibility -- and where we'd be stuck (for now) if I'm right
> -- is that 8000 bytes might be a real limit. I think to support
> inserting ntext data longer than that, we'd have to support the ODBC
> equivalent of dbwritetext/dbmoretext.
As they say in Sweden, "Ja, just det."
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_13_8orl.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlputdata.asp
In src/odbc/odbc.c, you'll find the implementation of SQLPutData(). This
is the function ODBC specifies for sending more than 8000 bytes of
text/ntext data. I'm not sure it's ever been used in the way you want to;
I think it was only implemented recently to support prepared statements
(dynamic SQL).
I don't know just exactly what shape SQLPutData() is in, or whether our
resident ODBC guru Frediano wants to work on it. Unless Frediano is much
further along with this than I think he is, there's no quick fix.
The problem sure seems to be in that vicinity. Of course, we don't know
exactly how the driver's being called, whether the caller realizes the
data exceed 8000 bytes and calls a (presumably) broken SQLPutData(), or if
it's just forming a giant INSERT statement (which, actually, I think,
would work fine). You could plop in a few logging statements of your own
to make sure.
Regards,
--jkl
-
[freetds] Function sequence error from Linux => SQL Server 2000,
Charles Bearden, 04/28/2004
- <Possible follow-up(s)>
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Lowden, James K, 04/28/2004
-
RE: [freetds] Function sequence error from Linux => SQL Server 2000,
Charles Bearden, 04/28/2004
-
Re: [freetds] Function sequence error from Linux => SQL Server 2000,
James K. Lowden, 04/28/2004
- Re: [freetds] Function sequence error from Linux => SQL Server 2000, James K. Lowden, 04/29/2004
-
Re: [freetds] Function sequence error from Linux => SQL Server 2000,
James K. Lowden, 04/28/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/28/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, ZIGLIO, Frediano, VF-IT, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, ZIGLIO, Frediano, VF-IT, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, ZIGLIO, Frediano, VF-IT, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/29/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, ZIGLIO, Frediano, VF-IT, 04/30/2004
- RE: [freetds] Function sequence error from Linux => SQL Server 2000, Charles Bearden, 04/30/2004
Archive powered by MHonArc 2.6.24.