Best way to connect to Firebird

Elements Oxygene
1

I am just getting started with Prism XE2 and I want to write a web application. What is the fastest way to connect to a Firebird database?

Thanks!

2

Have you tried the Firebird .NET provider?

3

Hello.

At first you need to install Firebird ADO.NET Data Provider at http://www.firebirdsql.org/en/net-provider/. Then create new Oxygene for .NET->Web->ASP.NET Web Application and follow the instructions described at http://rixxtech.blogspot.com/2008/10/using-firebird-with-aspnet.html with little adjusted point 7:

var fbCn:FbConnection := new FbConnection(“Database=Server=localhost;User=SYSDBA;Password=masterkey;”);
var fbDa:FbDataAdapter := new FbDataAdapter();
var fbCmd:FbCommand := new FbCommand();
var dt:DataTable := new DataTable();

fbCn.Open();
fbCmd := new FbCommand(“select * from ORDERS”, fbCn);
fbDa := new FbDataAdapter(fbCmd);
fbDa.Fill(dt);
GridView1.DataSource := dt

Hope this helps.

1 Like