🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: SQL errors

#616
From: Craig Stuntz
Date: Tue, 22 Jan 2002 18:34
33 lines
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!dnews
References: <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