Article View: borland.public.interbase.replication
Article #616Re: SQL errors
From: Craig Stuntz
Date: Tue, 22 Jan 2002 18:34
Date: Tue, 22 Jan 2002 18:34
33 lines
2170 bytes
2170 bytes
In article <3c4d9bed$1_1@dnews>, cplaquin@enrolnet.com says...
> I am encountering SQL errors using IB replicator during the creation of a
> new schema. I am running the open source IB replicator with an eval license
> with Firebird RC2.
Firebird has its own newsgroups and you should ask Firebird
questions there. This newsgroup is for InterBase.
> I am getting the following SQL error when I try to add a
> source database to my schema:
>
> Dynamic SQL Error
> SQL error code = -204
> Ambiguous field name between table PUBLISHEDDB and
> table DATABASES
> DBNO
>
> I have tried reinstalling the replication manager and server but this has
> not solved the problem.
Firebird has different rules for SQL than IB does, and it looks
like one of these rules is preventing it from working with IB-
Replicator. IB-Replicator (including the version of IB-Replicator for
IB Open Edition), as the name implies, is designed for InterBase, so the
chances of it working with an IB fork are not necessarily 100%.
-Craig
--
Craig Stuntz (TeamB) � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase WebLog: http://delphi.weblogs.com
InterBase PLANalyzer (Free IB optimization tool):
http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<MPG.16b77ab46d72fe7a98972a@newsgroups.borland.com>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:
<3c4d9bed$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: f89d7,a2dc2602a724e456 X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2002-01-22 10:36:57 PST From: Craig Stuntz <cstuntz@no_spam.vertexsoftware.com> Newsgroups: borland.public.interbase.replication Subject: Re: SQL errors Date: Tue, 22 Jan 2002 13:34:20 -0500 Message-ID: <MPG.16b77ab46d72fe7a98972a@newsgroups.borland.com> References: <3c4d9bed$1_1@dnews> Organization: Vertex Systems Corporation X-Newsreader: MicroPlanet Gravity v2.60 NNTP-Posting-Host: 208.235.151.194 X-Trace: dnews 1011724260 208.235.151.194 (22 Jan 2002 10:31:00 -0800) Lines: 33 X-Authenticated-User: cstuntz 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