views:

998

answers:

3

Hi there,

Could someone please explain the best way to connect to an Interbase 7.1 database using .NET/C#?

The application will be installed on many end user computers so the less "add-ons" that I will have to package with my application the better.

A: 

I think the Firebird .net provider is the same as the one that's in mono. Both are excelent btw.

horatio
Not exactly http://blog.cincura.net/230835-firebirdclient-and-interbase/
Hugues Van Landeghem
+2  A: 

CodeGear offers a free ADO.NET 2.0 driver for registered users of InterBase here:

http://cc.embarcadero.com/item/25497

Note that "registered users of InterBase" includes the free InterBase 2007 Developers Edition. The download says that it's for 2007, but it works fine with InterBase 7, and the InterBase team at CodeGear has told me that they have no problem with people using it for that purpose.

I do not recommend using a driver designed for Firebird, as InterBase and Firebird have somewhat different SQL syntaxes, and differ in other features, as well. In particular, I think that using any driver dependent on fbclient.dll with InterBase is outright dangerous.

Craig Stuntz
Thanks - this worked just fine. Example C# code was included in the read me as well.
Due to changes in CodeCentral, the URL specified will no longer work as expected. Please use http://cc.embarcadero.com/item/25497 instead
Cleggy
Thanks, Cleggy; fixed.
Craig Stuntz