Databases with Cake

    var $default = array('driver'    => 'adodb',
                         'connect'  => 'ibase',
                         'host'     => 'localhost:C:/path_to_db/db_name.FDB',
                         'login'    => 'sysdba',
                         'password' => 'masterkey',
                         'database' => '',
                         'prefix'    => '');
 

You should download ADOdb (http://phplens.com/adodb/) and copy it to directory app/vendors. Then change the file cake/libs/model/dbo/dbo_adodb.php - instead of “vendor(’adodb’.DS.’adodb.inc.php’);” there should be “vendor(’adodb’.DS.’adodb.inc’);”.

Enjoy!

To use a postgresql database the driver should be ‘postgres’

    var $default = array('driver'    => 'postgres',
                         'connect'  => 'pg_connect',
                         'host'     => 'localhost',
                         'login'    => 'username',
                         'password' => '*********',
                         'database' => 'caketest',
                         'prefix'    => '');

From: “ivanp” (12 Jan 2006 15:19:15 )

WOW!!!! I did’t!

Here is the config in anyone needs it in the future:

var $default = array('driver'   => 'adodb-access',
                         'connect'  => '',
                         'host'     => 'Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\www\jasol\access\jasol2000.mdb;Uid=Admin;Pwd=;',
                         'login'    => 'Admin',
                         'password' => '',
                         'database' => 'jasol2000.mdb' );

...and then you get this pretty message:

Your database configuration file is present.
Cake is able to connect to the database.