[posted and mailed, vänligen svara i nys]
Bj?rn Terje Svennes (sv*****@datec. no) writes:
I'm using ODBC to interface a Microsoft SQL Server 2000. One of the
operations involves placing files within BLOBs. I'm using the image
data type for this purpose. Most of the time this works okey, but when
trying to add a 21,3 MB file I get an error. The error code is 22001,
which means "String right-truncation". But why? Does this mean that
the field cannot accepts BLOBs with this size?
It is unclear which component is the source for the error, but I would
expect it to be the the SQL Server ODBC driver, since SQL Server, as far
as I know, has no limit, in the 20 MB range.
It could be that for large blobs, you cannot pass the entire blob in
one do, but you have to pass it in chunks. I don't have any experience
of passing BLOB data from ODBC, so I cannot say which exact functions
you should use, though.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp