Skip to Content.
Sympa Menu

freetds - Re: [freetds] Using dbwritetext against Ms-Sql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Using dbwritetext against Ms-Sql
  • Date: Fri, 25 May 2012 09:33:52 -0400

On Fri, 25 May 2012 12:15:33 +0000
Trygve Liland <Trygve.Liland AT visma.no> wrote:

> The problem is that we are getting
> tds_put_string: "writetext bulk IMAGECOLTAB.IMAGECOL
> 0x00000000000000000000000000000000 timestamp = 0x0000000000000000
> with log" Invalid text, ntext, or image pointer value
> 0x00000000000000000000000000000000.
>
> Any idea on what we are doing wrong? I have checked code that we have
> in another program where we used dblib against Ms-Sqlserver, and I
> see more or less the same code.

Those zeros are a problem, no doubt about it.

Do the db-lib unit tests t0013.c and t0014.c work with your server?
That would verify that dbwritetext() works with the TDS version you're
using.

The log doesn't record the value of the textptr returned by dbtxtptr.
If the server is sending a NULL textptr, see if that changes using TDS
7.1. If not, if you're receiving a good textptr from the server, you
need to find out why you're sending a NULL textptr.

Hälsingar,

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page