🚀 go-pugleaf

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) :(