Re: Using dbwritetext against Ms-Sql
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Fri, 25 May 2012 12:15:33 +0000 Trygve Liland <[email protected]> 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