ODBC error inserting data via ASP

ODBC error inserting data via ASP

Post by Rodne » Sat, 08 Nov 2003 03:55:24


I am working with a form on an ASP page and getting the
following error when attempting to insert data into my
MSSQL7 table which had been working fine.

Microsoft OLE DB Provider for ODBC Drivers
error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or
binary data would be truncated.
/respond.asp, line 90

Can someone tell me is this an invalid data issue or what
else it may be?

Thanks in advance.
Rodney
 
 
 

ODBC error inserting data via ASP

Post by Ali Bab » Tue, 11 Nov 2003 00:52:00


--------------020401090606000404080405--

Rodney,
This means that your ASP page is trying to insert data that is longer
than the allowed length. Let's say you have a field called firstname
defined as CHAR(15). If a client tries to insert more than 15 character
you will see this message.

Make sure that your program does not include invisible space characters
before or after the value, which will change the length.

AB


--

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

Rodney wrote:




<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body>
Rodney,<br>
This means that your ASP page is trying to insert data that is longer than
the allowed length. Let's say you have a field called firstname defined as
CHAR(15). If a client tries to insert more than 15 character you will see
this message.<br>
<br>
Make sure that your program does not include invisible space characters before
or after the value, which will change the length.<br>
<br>
AB<br>
<br>
<br>
<div class="moz-signature">-- <br>

<style type="text/css">
P {
font-family: Tahoma, Arial, Verdana;
font-size: 12px;
color: black;
}
H1 {}
H2 {}
H3 {}
HR{
line-height : 1;
text-align : left;
height : 1;
width : 80%;
color : #CC0000;
}
A {}
A:Visited {}
A:Active {}
A:Hover {}
BODY {
font-family: Tahoma, Arial, Verdana;
font-size: 12px;
color: black;
}
table {
font-family: Tahoma, Arial, Verdana;
font-size: 11px;
color: black;
}


</style>
<p> You don't pay to get spam, why pay to clean it?<br>
Visit <a href="http://www.spammarshall.com">http://www.spammarshall.com</a>
to create an account for free<br>
<a href="http://www.spammarshall.com" target="_blank"> <img
src="http://www.spammarshall.com/SpamMarshall/images/logo-g.gif"
border="0">
</a> </p>
</div>
Rodney wrote:<br>

<blockquote type="cite" cite="mid08c801c3a497$88ea9dc0$ XXXX@XXXXX.COM ">

<pre wrap="">I am working with a form on an ASP page and getting the
following error when attempting to insert data into my
MSSQL7 table which had been working fine.

Microsoft OLE DB Provider for ODBC Drivers
error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or
binary data would be truncated.
/respond.asp, line 90

Can someone tell me is this an invalid data issue or what
else it may be?

Thanks in advance.
Rodney
</pre>
</blockquote>
<br>
</body>
</html>