Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bulk Blob Truncation Error

Status
Not open for further replies.
deanlupini

deanlupini

Programmer
Mar 6, 2008
1
CA
I've been playing around with batch operations, and came across a strange problem. Any blob over 256kb is being truncated, the SQLExtendedFetch call returns the error. In my CRecordSet derived class for bulk transfers, I'm calling RFX_Binary_Bulk with a max size of 5mb. I increased this after I found the problem to find no change. It still truncates anything larger than 256kb. Does anyone have any idea on this? The limitation is not there for single row fetching, that code works fine. I'm connecting using ODBC.

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
917
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
395
Virendra Yaduvanshi
Virendra Yaduvanshi
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
432
dhookom
dhookom
kingz2000
  • Locked
  • Question
connection - runtime error (Excel to SQL-Sever) 1
Replies
2
Views
344
kingz2000
kingz2000
appelq
  • Locked
  • Question
SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas 1
Replies
7
Views
582
appelq
appelq

Part and Inventory Search

Sponsor

Back
Top