help:SQL Server error ' 80040e57'

Results 1 to 3 of 3

Thread: help:SQL Server error ' 80040e57'

  1. #1
    Join Date
    Dec 1969

    Default help:SQL Server error ' 80040e57'

    Hello All<BR><BR>************Problem I HAve***************<BR><BR>Microsoft OLE DB Provider for SQL Server error &#039 80040e57&#039 <BR><BR>String or binary data would be truncated. <BR><BR>************Problem I HAve***************<BR><BR>But The Same Query Run Successfuly in Sql Server Quesry Analyzer and on differnt ASP Pages..... <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: help:SQL Server error ' 80040e57'

    You are trying to insert data that is too long for the field - eg trying to insert a 60-character string into a varchar(25) field.<BR><BR>Dunc

  3. #3
    Michael Bunger Guest

    Default RE: help:SQL Server error ' 80040e57'

    I&#039ve run into the same error when I have used temporary recordsets and did not have the length of the field long enough. Make sure the lengths in the entire chain from input to database are adequate.<BR><BR>Hope that helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts