Saturday, February 25, 2012

Buffer size not specified error

Error: "The specified buffer size is not valid. [buffer size specified = 0]

Hello, im very new to SQL 2005 everywhere but looked like it could do the job for what i needed:

Im working on a c# (.net 2.0) project and loaded data

(one column from one table, 800 rows, text, no greater than 80characters in length)

from an access db into a data set, then lnserted the data in SQLce, great it works fab!

but as soon as I select another field(text, <=10) from the access db, and try to insert it into sql i get the error...

what have i missed?

could you post the code you are using to do the insertion and some info about the schema of the table you are inserting the records into? then we can see what's going on here.

thanks,

Darren

|||The problem was due to a field size not being long enough, i increased the field size and works great.

No comments:

Post a Comment