I just found today, how to the best configuration for DBO Driver of MsSQL in CakePHP 1.3.7

First, I have try to make a connection to SQL Server 2000, 2005, and 2008. The result is always:

Warning (2): mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.137.1\SQLEXPRESS,1433 [CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 154]
Warning (2): mssql_select_db() expects parameter 2 to be resource, boolean given [CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 159]

After done for googling in few day(s), I just found a bug based on error above, in

CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 154

It looks likely, configuration is always overwrite into this line. But after read an article about port problem for mssql driver in cakephp (forgoten about where is the article link), I try to change it to port => ”

And the result is still not connected, although I have try too in native php. And it’s works with simple line:

$myServer = "192.168.137.1\SQLEXPRESS"; //I used sql server 2008
$myUser = "sa";
$myPass = "xxx";
$myDB = "mesin_finger"; 

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

Next, trouble shoot continue to line before 154 in dbo_mssql.php: CORE\cake\libs\model\datasources\dbo\dbo_mssql.php

And the magic has come, after change $config['host'] to direct string ’192.168.137.1\SQLEXPRESS’, it’s WORK!
So, I just found the bug:

If I use $port as complete string in mssql_connect or mssql_pconnect, connection will not success, since in line 147 of dbo_mssql.php, I found this line:

} elseif ($config['port'] === null) {

It’s mean, we must set port configuration in database.php to null, NOT IN STRING value. The option is only null and numeric value.

Here are my database.php configuration:

var $attDbMsSqlServer = array(
                'driver' => 'mssql',
                'persistent' => false,
                'host' => '192.168.137.1\SQLEXPRESS',
                'login' => 'sa',
                'password' => 'xxx',
                'database' => 'mesin_finger',
                'prefix' => '',
                'encoding' => 'utf-8',
                'port' => null
        );

GOOD LUCK!!

Share on Facebook

Popularity: 20% [?]