Creates a PDO connection to MSSql server through Sybase dblib as a plugin for CakePHP 2.x
To many people on the Internet were looking for a simple way to connect to a MSSQL db from a linux installed cakePHP app. I was one of them so after hours of research the birth of this plugin was planned. A few hours later it was completed.
Update your composer.json
file using the following:
composer require cpierce/cakephp-sybasedb
Enable the Plugin in your app/Config/bootstrap.php
file:
<?php
CakePlugin::load('SybaseDB');
If you are already using CakePlugin::loadAll();
, then this step is not necessary.
Configure a database connection in app/Config/database.php
file:
<?php
class DATABASE_CONFIG {
public $default = array(
'datasource' => 'SybaseDB.Sybase',
'host' => 'someplace\SQLEXPRESS',
'login' => 'somelogin',
'password' => 'Ur_P4ssw0rd#',
'database' => 'some_database',
);
}
You could also use another connection instead of $default
and then specifying $useDbConfig
in your model.
From here you can now access the data the normal cakePHP way:
<?php
$this->Model->find('first');
Some of the code used was taken from the CakePHP 1.x SQLServer DBO for Microsoft Windows and altered to fit the PDO DBlib. Special thanks to the people who have used this and helped me test it (Especially Jeffery Bell and Marcel Wedel)
Version 1.0
Version 0.3b
Version 0.2b