[AccessD] Nvarchar(max)

[Anita Smith]

Hi Group,

Just a short note to let you know that I have spent most of the day troubleshooting an application that have been in use for well over a year that has suddenly stopped working in one area.

After a lengthy process of elimination I have worked out that using nvarchar(max) fields on continuous forms have stopped working (the screen would freeze and throw an ODBC query timeout error).

There must have been an update in the last week to have caused this as the app on site and my old development app here both encountered the same issue. I also found the same issue in various versions of ODBC as well as various versions of SQL Server- yes, I really have been through the wringer today, trying everything under and over the sun.

Anyhow, change the field to something else and the problem is solved.

Beam me up Scotty!

Anita


 
Anita Smith 

M: 0402 022 462
E: anita at ddisolutions.com.au

Custom Software, Databases and Websites

Please consider the environment before printing this email.


The content of this message is confidential. If you have received it by mistake, please inform us by an email reply and then delete the message. It is forbidden to copy, forward, or in any way reveal the contents of this message to anyone. The integrity and security of this email cannot be guaranteed over the Internet. Therefore, the sender will not be held liable for any damage caused by the message.