🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #652

Re: Syncchronise V's Replicate

#652
From: Steve Ball
Date: Tue, 30 Oct 2001 17:49
53 lines
2982 bytes
Yes I have it working fine.

I move Blobs (rich text and pitcure) between databases not a problem.
I replicate between tables through stored procedures as well (and although
you need to be very precise when setting these up, there worth their
original set-up time in gold. Infact its now quick for me to set up the
scheme for new sites when using the stored procedure)

The replication is very fast, Sycronising is slower as its doing more work.
I've never had any problems getting it to replicate, are you sure you have
enabled replication in the scheme on the source database (right click source
database; choose setting; Replication enabled should be checked)
If you click on replicate what happens? does anything happen? do you have a
log created?

I would check also that you can connect to the databases using the usernames
and passwords set out for the replication (you can do this under the source
database on the scheme, right click choose edit and test connection from the
connections page. I would also check you have granted full options to the
tables for the user name as this connection will not check this. Also are
you replicating from table to table, or via a procedure for example?

Steve

"gearoird o riain" <gearoid_o_riain@hotmail.com> wrote in message
news:3bd9454d_1@dnews...
> Hi Again...
>
> We are having a little more success on our internal netwrk now..
>
> but IB Rep will not "repplicate". Data will only transfer if we enable
> Synchronise in the Schemas and Default setting and then click the
> Synchronise button in IBREPLSERVER..
>
> It seems very slow and when the records do appear in the other database
> there are no pictures transferred...
>
> Also the initial edit attempt on the record sent results in an "Invalid
> Variant" message..
>
> Anyone know if we should sync or replicate... what is the difference...
>
> does IB Rep do jpgs which are stored as blobs...
>
> Again... does anyone have this working ina  commercial environment
> without problems?
>
> --
> Regards
>
> Gerry Ryan
>
>
Technical Details
Message-ID: <3bdee825_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3bd9454d_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,8a7db25421b7ea09
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2001-10-30 09:59:44 PST
From: "Steve Ball" <Steve@ClubRunner.co.uk>
Newsgroups: borland.public.interbase.replication
References: <3bd9454d_1@dnews>
Subject: Re: Syncchronise V's Replicate
Date: Tue, 30 Oct 2001 17:49:25 -0000
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 195.173.39.197
Message-ID: <3bdee825_2@dnews>
X-Trace: dnews 1004464165 195.173.39.197 (30 Oct 2001 09:49:25 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews