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. Is there a way to export a preview?

3. sample data models for real estate

4. comparation !!!

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

6. trouble with columns_udpated() clause

7. SQL6.5 over a 64K ISDN line

8. Text Field cutting off at 64K

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

10. OLAP Services, 64K members per parent limit

11. sql_cmd TextCopy 64K limitation?