I had this Problem too.
If there is one record bigger than 100 Chars in your field you will not be able to read that field with a SQL Connection.
Try to set a new SQL field width. Maximum: 31995
@jongpau
The Problem is not cause of missing double quotation marks. But thanks for the tip. I also had to search for this solution.:)
I tried the second tip of you, I also read on other sites in the internet.
On a trainings DB i impoved the SQL Field width and it worked well.
But I dont...
I've got the same Problem using it in a ASP.
There are several Fields including Data but if I read them in my .asp File they are empty.
If I read them with read/write connection, I get the errormsg: "....has value exceeding its max length or precision"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.