AppendChunk problems with SQL Server

AppendChunk problems with SQL Server

Post by Riaz Bord » Wed, 27 Feb 2002 01:05:33



All,

If you've been having problems with ADO AppendChunk , while trying to
send images to SQL Server and have tried zillions of techniques from
the various postings, the following might help :

Your code, drivers, images, etc might be fine. The problem (which was
mine) is the size limit on SQL Server when a table is set for
replication.
Using "sp_configure", check out the option "max text repl size". It
should be 65536 bytes by default. If the size of your images are
bigger, the AppendChunk will fail if the table is set for replication.
Execute : "sp_configure 'max text repl size', xxxx" replacing xxxx by
your size limit and then execute "RECONFIGURE" or restart the SQL
Server.

Solved my problem indeedy... Got a new problem now : storage space!!!

rZ :-)

 
 
 

1. AppendChunk problems with SQL Server

All,

If you've been having problems with ADO AppendChunk , while trying to
send images to SQL Server and have tried zillions of techniques from
the various postings, the following might help :

Your code, drivers, images, etc might be fine. The problem (which was
mine) is the size limit on SQL Server when a table is set for
replication.
Using "sp_configure", check out the option "max text repl size". It
should be 65536 bytes by default. If the size of your images are
bigger, the AppendChunk will fail if the table is set for replication.
Execute : "sp_configure 'max text repl size', xxxx" replacing xxxx by
your size limit and then execute "RECONFIGURE" or restart the SQL
Server.

Solved my problem indeedy... Got a new problem now : storage space!!!

rZ :-)

2. DO YOU NEED TO UPGRADE YOUR OLD FileMaker Pro FILES?

3. SQL Server error with AppendChunk in VB4

4. GA-ORACLE INFORMATION TECHNOLOGY

5. VB4.0/SQL server - GetChunk/AppendChunk behave oddly

6. NAIUA OpenROAD Web Page Update

7. GetChunk and AppendChunk - works with ODBC/SQL Server?

8. SQL 6.5 replication Howto?

9. VB4.0/SQL server - GetChunk/AppendChunk behave oddly

10. Saving an image with AppendChunk problem

11. Strange problem with appendchunk, stranger solution yet