Help!! Problem on MSSQL BLOB fields replication !!

Dor-Bujor

Delphi Developer

Sun, 21 Mar 2004 21:46:15 GMT

Help!! Problem on MSSQL BLOB fields replication !!

I have 2 servers running MSSQL Server 7.0.
1 Main Server
2 Mirror Server.

The main server initiates replication to the mirror server at each 3 min.
On a table located on the main server there is a BLOB field used for some
text data
and another one used for images.
When I append a new record on the main table, the BLOB fields are correctly
replicated in the mirror database.
But When I perform an Edit of these fields (to update on main database),
after replication, the fields from the mirror database are damaged. The
image field (used to store a JPG image) reports to the client invalid format
, and the memo field is empty.

Can you give me an advice?
Thanks a lot!

Dor-Bujor

Dor-Bujo

Delphi Developer

Sun, 21 Mar 2004 21:59:16 GMT

Re:Help!! Problem on MSSQL BLOB fields replication !!

I have 2 servers running MSSQL Server 7.0.
1 Main Server
2 Mirror Server.

The main server initiates replication to the mirror server at each 3 min.
On a table located on the main server there is a BLOB field used for some
text data
and another one used for images.
When I append a new record on the main table, the BLOB fields are correctly
replicated in the mirror database.
But When I perform an Edit of these fields (to update on main database),
after replication, the fields from the mirror database are damaged. The
image field (used to store a JPG image) reports to the client invalid format
, and the memo field is empty.

Can you give me an advice?
Thanks a lot!

Dor-Bujor

Other Threads

1. MsSql Blob Field Problems in Delphi 4.0

2. Problem inserting blob field into another blob field using two ibsql

3. Help with MSSQL Blob Insert Problem

4. MSSQL SP3 and BLOB problems - Please Help!

5. MSACCESS: Problems with AutoInc-Field, Type: Replication-ID

6. retreiveing bitmap and assign at blob field (MSSQL 2000)

7. MSSQL 6.5 with BLOB Fields

8. MSSQL and blob field

9. Blob/Memo fields and MSSQL 7 (Beta-3)

10. blob field problem, pls help.