SQL Problem

_anil_

I want to insert a large binary data in to database( SQL server 2000 ) using VC6. First I tried with RFX_Binary, with CByteArray but in that case I was able to insert only 8000 byte of data. After that data trunctaion error occures. Then I tried with CLongBinary but in MFC RBX_LongBinary don't support. As I got assert at void AFXAPI RFX_LongBinary(CFieldExchange* pFX, LPCTSTR szName, CLongBinary& value) { : : : case CFieldExchange::BindParam: // CLongBinary parameters are not supported ASSERT(FALSE); : : : } Please suggest any method to try.

Regards Anil

Chris Losinger

the 'binary' data type itself can only hold 8K bytes. SQL data sizes

image processing toolkits | batch image processing | blogging

David Crow

What type of field is the CByteArray object mapped to in the SQL table? The char, varchar, binary and varbinary types are limited to 8,000 bytes.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

_anil_

in SQL table its image type. When I write SQL statement in SQL manager I am able to insert more than 8K. Its in the MFC side giving data truncation exception.

Regards Anil

_anil_

in SQL table its image type. When I write SQL statement in SQL manager I am able to insert more than 8K. Its in the MFC side giving data truncation exception. Regards Anil

Regards Anil

David Crow

What does your RFX_Binary() statement look like?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

_anil_

RFX_Binary(pFX, _T("[@File]"), mFileParam, 800000); here I have given size more that 8000

Regards Anil