Error -2147467259. Data too long for column 'X' at row 1.

[HP_GS]

I am new to SQL and I get this error when I try to add another row into the SQL database whose width is different that the corresponding element on the previous row.

For eg

If I enter the string "test" as the an element in the first row, there is no error. However, if I enter "test1" , it throws the following error. I set the data type as string and size to 0( max length for SQL).

Any help is appreciated.

Thanks

HP

[Yamaeda]

Stringcol sounds like a number, no? Without seeing your table definition it's hard to say, but most likely the error is correct, you're trying to enter e.g. a 5 byte string into an integer field (which is 4 bytes), or similar.

/Y