ODBC + Cake 1.3

[Philip Thompson]

Hi all.

Been doing some digging around google and haven't found much on the topic of
CakePHP 1.3 + ODBC support. From my understanding, 1.2 allowed ODBC
connections, but it doesn't appear as though 1.3 does. The listing of
datasources are found in /app/cake/libs/model/datasources/dbo/...

dbo_mssql.php, dbo_mysql.php, dbo_mysqli.php, dbo_oracle.php,
dbo_postgres.php, dbo_sqlite.php

<file:///P:/wp/cake/libs/model/datasources/dbo/dbo_sqlite.php>The git repo
shows others:
https://github.com/cakephp/datasources/tree/master/models/datasources/dbo

So my question, is/will Cake support ODBC for 1.3 and/or later?

My initial setup shoots back an error:

*Fatal Error* (256): ConnectionManager::loadDataSource - Unable to
import DataSource class .DboOdbc
[*CORE/cake/libs/model/connection_manager.php*, line *185*]

Code <javascript:void(0);> | Context <javascript:void(0);>

        if (!App::import('Datasource', $class,
!is_null($conn['plugin']))) {
trigger_error(sprintf(__('ConnectionManager::loadDataSource - Unable
to import DataSource class %s', true), $class), E_USER_ERROR);

$connName       =       "ws"
$_this  =       ConnectionManager
ConnectionManager::$config = DATABASE_CONFIG object
ConnectionManager::$_dataSources = array
ConnectionManager::$_connectionsEnum = array
$conn   =       array(
        "plugin" => null,
        "classname" => "DboOdbc",
        "parent" => array(
        "filename" => "dbo_source",
        "classname" => "DboSource",
        "parent" => null,
        "plugin" => null
),
        "filename" => "dbo/dbo_odbc"
)
$class  =       ".DboOdbc"

ConnectionManager::loadDataSource() -
CORE/cake/libs/model/connection_manager.php, line 185
ConnectionManager::getDataSource() -
CORE/cake/libs/model/connection_manager.php, line 109
Model::setDataSource() - CORE/cake/libs/model/model.php, line 2833
Model::__construct() - CORE/cake/libs/model/model.php, line 469
ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 141
Controller::loadModel() - CORE/cake/libs/controller/controller.php, line 641
Controller::constructClasses() -
CORE/cake/libs/controller/controller.php, line 497
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 186
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

My configuration is like so:

class DATABASE_CONFIG {
    var $ws = array(
        'driver' => 'odbc',
        'connect' => 'odbc_connect',
        'persistent' => false,
        'host' => 'localhost',
        'port' => '',
        'login' => 'pizza',
        'password' => 'pizza',
        'database' => 'theDataSource',
        'schema' => '',
        'prefix' => '',
        'encoding' => ''
    );
}

Any thoughts or guidance would be greatly appreciated.

Thanks,
~Philip

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en