I receive this error when trying to add a link: Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
/forum/links_add_url.asp, line 77
I have my field for the Description set to 1500 (char) and Keywords set to 1000 (char). I do not see any limits in the ASP pages & I did this on the other fields & it worked.
It was also work when I had it on my Access 2000 DB.
I am using MS SQL2000. Not too sure what else I might be missing?
quote:I have my field for the Description set to 1500 (char) and Keywords set to 1000 (char). I do not see any limits in the ASP pages & I did this on the other fields & it worked.
I thought the limit on a text field was something like 254 characters. Anything more than that would use a memo field.
I went into the form field for keywords and limited the character length to whatever the database allowed for in that field. That takes care of the keywords but it still gives me a problem in the description field. Whenever I run into that problem, I either just take out a sentence or bring the entire description into MS Word which tells me how many characters there are and make adjustments from there.
Bookie
"May the forces of evil become confused on the way to your home." - George Carlin
I know that I am not using over 1,000 characters though. It should not be that much. I might be using more than 255 character. You are correct about the limit if you are using MS access, but MS SQL allows more characters per field.
Topic Locked
Posted - 31 July 2002 : 17:06:02
