String Data, Length Mismatch

Question

Post reply

String Data, Length Mismatch

Mayuresh

Mr or Mrs. 500

Points: 520
More actions
May 20, 2005 at 4:54 am

#362603

This error is intermittent.
I am getting this error when i transfer image data from one server to another Server(My web server) using internet.
I have designed a DTS package in vb and calling it to perform above operation. we are using this package for almost 7-8 months. never had this problem. suddenly we are getting this error very frequently. But sometimes it does transfer data to destination server.
Error Details
String Data, Length Mismatch (80040e21) Connection.open(Write());General Network Error
******************

MayurArt

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jfb SSCrazy Points: 2469 More actions · Answer 1

This is permission error problem.

Check all the permissions that you are using on the network or store procedures that you are using.

Rgds

JFB

Mayuresh Mr or Mrs. 500 Points: 520 More actions · Answer 2

Hi JFB,

thanks for ur reply. but with other SQL tables w/o image or text columns it works. and some times it does allow me to upload image data (same table) also.

MayurArt

jfb SSCrazy Points: 2469 More actions · Answer 3

Ok then the other option should be OLE DB error. The error 80040e21 indicates that the field is too small to accept the amount of data you attempted to add. For example, the error 80040e21 may be caused by trying to insert 12 characters into a SQL Server field that is formatted to accept only 10 characters. In this case, you should insert less data.

Mayuresh Mr or Mrs. 500 Points: 520 More actions · Answer 4

I dont think this could be the problem. i have already run the same script of source Database on Destination Server Database. hence making the two table identical. I strongly feel it must be because of internet speed as it uploads same records later.

MayurArt