Solved

Microsoft OLE DB Provider for SQL Server error '80040e57'

Posted on 2003-11-18
4
966 Views
Last Modified: 2012-06-21
accountManagerID= 2
assignedto=
select * from crm_accountManager where accountManagerID = 2
19-11-2003 9:53:14 AM
2003-11-19 9:53:00.000
INSERT INTO crm_notes (contactID, accountManagerID, noteDate, noteTime, noteTypeID, [note], noteDateFollowUp, noteTimeFollowUp, followUpNote) VALUES (1769, 67,CAST('2003-11-19 9:53:00.000' as smalldatetime),'', 8, 'test', '2003-12-19', '9:52:46 AM', '')
INSERT INTO crm_noteOutbound (noteID, callType, custReaction, noPurchase, price, callOutcome, term) VALUES (28235, 'general', 'other', 'expensive', 'competitive price', 'negative','Term 1')

Microsoft OLE DB Provider for SQL Server error '80040e57'

String or binary data would be truncated.

/note_action.asp, line 189


Coding should be right, just with the data base area I think could some one help?

Xenia
0
Comment
Question by:XeniaGoh
  • 2
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 20 total points
ID: 9775918
This means you're passing data too the database that is too long for your defined definition.  Verify your field definitions in the database and compare the lengths with the data you're trying to insert...
0
 
LVL 8

Expert Comment

by:dishanf
ID: 9779218
If you use
SET ANSI_WARNINGS OFF
Then Data will be truncated . But this is not good thing to do.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9779241
Exactly--changing the ANSI settings only masks the problem.....
0
 
LVL 8

Expert Comment

by:dishanf
ID: 9784656
Yes I agree with arbert
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question