Article View: borland.public.delphi.database.dotnet
Article #149Re: BDPDataAdapter SQL generation
From: Albert Zuzej
Date: Sat, 20 Aug 2005 15:11
Date: Sat, 20 Aug 2005 15:11
45 lines
2675 bytes
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-mailReferences:
<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