Article View: borland.public.interbase.replication
Article #652Re: Syncchronise V's Replicate
From: Steve Ball
Date: Tue, 30 Oct 2001 17:49
Date: Tue, 30 Oct 2001 17:49
53 lines
2982 bytes
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!dnewsReferences:
<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