🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.database.dotnet
Article #149

Re: BDPDataAdapter SQL generation

#149
From: Albert Zuzej
Date: Sat, 20 Aug 2005 15:11
45 lines
2675 bytes
Hello Kostas,

thank you for the hint. I just downloaded the Firebird Data Provider 
from http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_download_dotnet
and will determine, whether that works.

Kostas Terzides schrieb:

> Albert Zuzej wrote:
> 
>> Hello,
>>
>> I am trying my first steps with data access in ASP.NET (Delphi). I 
>> have added BDPConnection to my project and connected it to a firebird 
>> database (employee or mastsql). The test of the connection is positiv. 
>> Now I have added a BDPDataAdapter. It shows the tables correctly. When 
>> I hit the "SQL generieren" (german version of generate SQL) button I 
>> always receive the error message:
>>
>> Ambiguous fiel name between table RDB$RELATIONS_CONSTRAINTS and table 
>> RDB$RELATIONS RDB$RELATION_NAME.
>>
>> This message appears with all databases and tables.
>>
>> Has anybody an idea, why?
>>
> 
> Take a look at b.p.d.database.bdp a thread called "BDPAdapter, 
> parameters, error with Firebird" started at July 7 by Gregory.
> 
> I also have the same problem. I believe the reason is what Greg pointed 
> out.
> 
> <quote>
> I guess it is just that I was using the Interbase Provider with a Firebird
> 1.5 Database...
> 
> It's really a pity that the bdpconnection components cannot recognise the
> Firebird provider when installed.
> </quote>
> 
> 
> I think we'll just have to wait for the Firebird specific BDP components 
> (or contribute to them)  (there are still in alpha version) or use the 
> ADO.NET firebird component (and build all SQL clauses in code) :(
Technical Details
Message-ID: <4307481e@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.spamkiller.net!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
References: <4307279d$1@newsgroups.borland.com> <43073d36@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,e20d4e51091a6fb9
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 20 Aug 2005 17:11:37 +0200
From: Albert Zuzej <AlbertZuzej@aol.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.4) Gecko/20030619 Netscape/7.1 (ax)
X-Accept-Language: de-de, de
MIME-Version: 1.0
Newsgroups: borland.public.delphi.database.dotnet
Subject: Re: BDPDataAdapter SQL generation
References: <4307279d$1@newsgroups.borland.com> <43073d36@newsgroups.borland.com>
In-Reply-To: <43073d36@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 217.185.9.1
Message-ID: <4307481e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1124550686 217.185.9.1 (20 Aug 2005 08:11:26 -0700)
Lines: 46
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.moat.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.spamkiller.net!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail