Well this shows how easy porting application is using ADOdb.

TikiWiki has switched from PEARdb to ADOdb, but had not got
a Firebird script. I've just posted that to the files
section, and here are the rest of the notes.

tikilib.php
Line 366
$query .= " where ttf.`fieldId`=ttif.`fieldId` and
ttif.`itemId`=tti.`itemId` and `type`=? and tti.`status`=?
and `value`=?";
to
$query .= " where ttf.`fieldId`=ttif.`fieldId` and
ttif.`itemId`=tti.`itemId` and ttf.`type`=? and
tti.`status`=? and ttif.`value`=?";
While fields are unique, qualifying prevents possible
problems later

line 394
$query .= " where ttf.`fieldId`=ttif.`fieldId` and
ttif.`itemId`=tti.`itemId` and `type`=? and tti.`status`=?
and value=?";
to
$query .= " where ttf.`fieldId`=ttif.`fieldId` and
ttif.`itemId`=tti.`itemId` and ttf.`type`=? and
tti.`status`=? and ttif.`value`=?";
As above, but problem was the missing `` round value

tikidblib
Add after line 158
case "firebird":

same as postgres and sybase ( at present )

lib/adodb/drivers/adodb-ibase.inc.php
Line 638
$fld->name = strtolower($ibfalias>'alias');
to
$fld->name = $ibfalias>'alias';

This looks like a long time 'PROBLEM' with ADOdb - but I
only used upper case field names until now.

Create a TIKIDB database with the script, and add a
local.php file to /db containing

<?php
$db_tiki="firebird";
$dbversion_tiki="1.8";
$host_tiki="engineering";
$user_tiki="SYSDBA";
$pass_tiki="masterkey";
$dbs_tiki="TIKIDB";
?>

And TikiWiki is ready to go, and not a MySQL database in
sight :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services