Only a couple of the users are gettin this error. I have a hard time duplicating it. They are using Windows XP with IE6. Daveo asked me to start a new thread on this.
Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. /post_info.asp, line 1211
my Line 1211 is: my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
There are a few other topics with simular errors. I have a 2003 server with MS SQL 2000. Snitz Version 3.4.06, 3mb up/down connection.
FYI- My data is not too long, we tried a simple "Hello".
A likely cause of this *at a db level* would be if the strSQL is being built up with parameters in their wrong places etc so a big lump of text was trying to squish into a char(10) for instance. before the execute, whyt not try a response.write of strsql, see what's being generated and it'll give you mighty big clues
I had this issue under 3.4.06. The error was this: Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. /post_info.asp, line 1044
I figured that the IP column(s) weren't big enough so I did the following and the error disappeared: ALTER TABLE [FORUM_A_REPLY] ALTER COLUMN [R_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_A_TOPICS] ALTER COLUMN [T_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_FORUM] ALTER COLUMN [F_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_MEMBERS] ALTER COLUMN [M_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_MEMBERS] ALTER COLUMN [M_LAST_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_MEMBERS_PENDING] ALTER COLUMN [M_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_MEMBERS_PENDING] ALTER COLUMN [M_LAST_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_REPLY] ALTER COLUMN [R_IP] nvarchar(50) NULL GO
ALTER TABLE [FORUM_TOPICS] ALTER COLUMN [T_IP] nvarchar(50) NULL GO <
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
Topic Locked
Posted - 05 November 2006 : 10:21:33
