No images over 64K

No images over 64K

Post by eol.. » Wed, 05 Apr 2000 04:00:00


Hi Everyone,
        Have a little problem with image fields. whenever i try and
insert a binary file into a image field that is larger than 64K, i get
the error:

// from sql server, platform SDK
#7139
"Length of text, ntext, or image data (%ld)
to be replicated exceeds configured maximum %ld."

i should mention that this problem only happens on one of our
databases. I have no problems inserting the same records into other
databases even located on the same server. however i haven't been able
to find any configuration settings that seem to indicate a limit on the
size of this field.

Does anyone know a place where you configure this information?
Does anyone know if this could be caused by some sort of corruption of
the DB?
Does anyone have any idea what could be causing this?

Thanks a ton!
Eric

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

1. No images over 64K

Hi Everyone,
        Have a little problem with image fields. whenever i try and
insert a binary file into a image field that is larger than 64K, i get
the error:

// from sql server, platform SDK
#7139
"Length of text, ntext, or image data (%ld)
to be replicated exceeds configured maximum %ld."

i should mention that this problem only happens on one of our
databases. I have no problems inserting the same records into other
databases even located on the same server. however i haven't been able
to find any configuration settings that seem to indicate a limit on the
size of this field.

Does anyone know a place where you configure this information?
Does anyone know if this could be caused by some sort of corruption of
the DB?
Does anyone have any idea what could be causing this?

Thanks a ton!
Eric

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Progress Developers needed - Seattle.

3. no images over 64K

4. US-FL-JD EDWARDS ENTERPRISE REPORT WRITER CONSULTANT / ORACLE

5. No images over 64K

6. Q: Oracle8 and MS-Techniques (ADO,OLE-DB,MTS)

7. Text and Image data handling - more than 64K

8. Use Bulk Insert to take XML and pass to text field?

9. SQL6.5 over a 64K ISDN line

10. Text Field cutting off at 64K

11. ODBC SQL Statement length limit of 64k???

12. OLAP Services, 64K members per parent limit

13. sql_cmd TextCopy 64K limitation?