Re: Subject: [Firebird-net-provider] Questions about the .NET Data provider

[<CAR...@te...>]

Hello=3A

=3E I=27m developing an app in C++=2C and was intending to use
=3E Ado (not the =2ENET version)=2C because the target was not
=3E to be a =22managed=22 program=2C but an =22unmanaged=22 program
=3E (and I had considered the free MSDE SQL engine from
=3E MS)=2E However=2C in case of larger database requirements=2C
=3E I wanted to avoid the =241500 charge for MSSQL=27s =22full=22
=3E version (small package)=2C so Firebird seemed really
=3E attractive (and so did MySQL)=2E

Huummm if i can give you an advice =3A) use Firebird !!=2C MSDE has a =

limitation of five users=2C if i remember well=2C and MySQL lacks=2C at t=
his =

moment=2C some interesting features as Triggers=2C Stored Procs=2C =

Referential integrity=2C =2E=2E=2E =


=3E However=2C I never could get any of the ODBC or OLE DB
=3E drivers for Firebird to work=2C except for the one
=3E =22sanctioned=22 by Borland from Easysoft=2E That worked=2C
=3E but then I saw =2ENet provider=2C and reconsidered (for
=3E perhaps time 4) what connection methods I should use=2E

Have you tested the IBPhoenix ODBC Driver =3F=3F=3F =

( http=3A//www=2Eibphoenix=2Ecom/main=2Enfs=3Fa=3Dibphoenix=26page=3Dibp=5F=
60=5Fodbc )

=3E The only thing I noticed=2C outside of a requirement for
=3E the transaction which I=27m not sure I understand well
=3E enough to even object=2C or just use=2C is the absence of
=3E support for the DataSet object=2E That would allow use
=3E of all the other =22goodies=22 in ADO=2ENET that depend upon
=3E DataSet (and perhaps=2C too=2C DataTable)=2E

Huuumm the =2ENET framework has a independent Dataset/DataTable classes =

that can be used with any ADO=2ENET Provider=2E

=3E Frankly=2C though=2C I=27m just fine without it=2C because I
=3E have my own data management features that perform the
=3E functions typical of DataSet=2C and I=27ll abstract from
=3E there toward my application code=2E
=3E =

=3E I=27m a few months away from completing my own
=3E application=2C and I=27m continuing to evaluate just what
=3E providers or connection methods are best for me to
=3E use=2C but this =2ENET data provider has=2C in just my test
=3E evaluations=2C done what I need it to do=2E =

=3E =

=3E As I get closer to my target release=2C let me ask=2C in
=3E what way may I return the favor - such as a
=3E contribution to your cause=2E I don=27t see that a license
=3E is required to use or include the =2ENet provider in my
=3E distribution (unless I=27m mistaken)=2C but if I=27m going
=3E to benefit from it=27s use=2C it=27s only good business to
=3E support it=27s development=2E

There are some ways to contribute=3A

	- Sending bug reports =

	- Sending patches=2E
     	- Sending suggestions about new features or modification for =

existing one=2E=2E
     	- =2E=2E=2E
     	- For money support i think the best way is to help using the =

Firebird Foundation =

	( http=3A//www=2Efirebirdsql=2Eorg/ff/foundation/ )=2E

The provider has LGPL license=2C i don=27t know the details about it =3A)=
=2C =

but i think you can use without problems with comercial and non-
comercial applications=2C as i know the limitation is that if you make =

modifications to the source code and you want to distribute them you =

need to make them public (if i=27m wrong please correct me =3AD)=2E





--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain