[orm-devel] Firebird adapter

Werner F. Bruhin orm-devel@mailman.tux4web.de
Fri, 28 Feb 2003 10:58:07 +0100


Forgot a step if you use FB 1.5 beta.

You need to copy fbclient.dll and gds32.dll from firebird/bin to 
windows/system32 directory.

Sorry about this
Werner

Werner F. Bruhin wrote:

> Firebird has released Beta 3, hoped to get some support in that beta to
> allow the implementation of the ORM adapter for Firebird to have just
> one stored procedure.  Unfortunately it did not make it and the Firebird
> developer would/could not give a date nor which beta would contain that
> patch so I decided to go ahead and implement it with what is there now 
> (an advantage is that it supports FB 1.02 and might even work for 
> Interbase, so that I don't know for sure).
>
> This means that per generated column (autoinc in Firebird) we will need
> a Generator and one stored procedure.  To facilitate this I created an
> "fbgen.py" which generates the Firebird class definitions and the SQL to
> create the generator and the stored procedure, one just has to copy/past
> this into a SQL script exec like ibexpert to create things in the db.
>
> Here some links were you can get some stuff you will probably need/want.
>
> *Firebird DB* (really any release, at least for the moment):
> http://www.firebirdsql.org/
>
> If you get beta 3 you have to do some manual install steps (at least on
> Windows):
> - extract ZIP file to e.g. c:\program files\firebird
> - go to c:\program files\firebird\bin
> - instreg install "c:\program files\firebird" -z
> - instsvc install "c:\program files\firebird" -auto -g
>
> *Python Extension package for Firebird*
> http://kinterbasdb.sourceforge.net/
>
> *Firebird manager* (stop/start if installed as service, support of
> multiple versions of FB)
> http://www.achim-kalwa.de/dl/fbmgr-setup.exe
>
> *DB managing/adminstration tool
> *I use IBExpert personal edition (free), tried out full version which
> includes additional tools such as Grant Manager, User Manager, SQL
> debugger and DB design tool which can reverse engineer DB (I did a
> Paradox DB to FB, without any problems - requires a plug in).
>
> http://www.hksoftware.net/download/ibep_2.5.0.22_full.exe  (link to
> personal version which is free)
>
> Other options are:
> www.ibaccess.org
> http://ems-hitech.com/ibmanager/
>
> Hope I did not forget anything - obviously you will need latest version
> of ORM (see next posting).
>
> See you
> Werner
>
>
>
>
> _______________________________________________
> orm-devel mailing list
> orm-devel@mailman.tux4web.de
> http://mailman.tux4web.de/mailman/listinfo/orm-devel
>
>