TD 5.2 SP1 Critical error on MS SqlServer

[Nils Jänicke]

Send a command like
UPDATE table SET longfield = :longstring WHERE key = :nValue
Send this command using SqlPrepare to the database (longfield is from type text, ntext, image, varchar(max), nvarchar(max) or varbinary(max))
Then fill the longstring variable with a string and use an existing row in the where clause.
Then execute the command using SqlExecute.
Then clear the variable longstring, select another row in the where clause and execute again using SqlExecute.
Then an error occurs, sometimes a pointer error, sometimes a truncate message from the database.

Try the example on a Microsoft SqlServer database and click all buttons from top to bottom.

THIS IS A CRITICAL ERROR for us.

[Jeff Luther]

Can't duplicate this. I'm testing with MS SS 2005 using ODBC SQL Native client. I clicked Update Memo 3 times and no error. Here's what your output looks like:

JL-CannotDuplicateAnyError.png

All I did was widen the ML field so I could see all the text.

[Nils Jänicke]

This is the error on my system:

Microsoft SQL Server:7125[Microsoft][ODBC SQL Server Driver][SQL Server]Der text-, ntext- oder image-Zeigerwert steht in Konflikt mit dem angegebenen Spaltennamen.[Mic

Any changes to the routers not shipped with TD 5.2? Did you try this on a SQLServer 2008? German OS and german database?

This is a CRITICAL error for us. Please help me.

Nils

[Nils Jänicke]

Version information:
Sqlodb32.dll Date 2010-03-08, Version 5.2.1.16227 5.2-SP1, Build 16227
sqlws32.dll Date 2010-01-19, Version 5.2.1.15186 5.2.1 S Build 15186
sqlwntm.dll Date 2010-01-19, Version 5.2.1.15186 5.2.1 S Build 15186

[Nils Jänicke]

I think I have found the problem.
The error occurs only on using the longbuffer keyword in sql.ini and using big values for it.
longbuffer=262144 works fine, but longbuffer=524288 gives the error.
So I can reduce the setting of the longbuffer to 262144 and so this is no longer a problem for us.

Nils

[Jeff Luther]

Thanks for letting us know. Mine's set to:
[odbcrtr]
longbuffer=250000