Hello
Im having a big problem trying to connect YYI whtich MS SQL EXPRESS 2005
im using XAMP server,on a VM with WServer 2003 R2 32 bit
with PHP 5.4.31
y donwload and install
php_pdo_sqlsrv_54_ts.dll
php_sqlsrv_54_ts.dll
also de MS SQL Native client 2005
and y try connecting with this script
<?php
$serverName = "200.xxx.xxx.xxx.\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"test4", "UID"=>"test", "PWD"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Conexión establecida.<br />";
}else{
echo "Conexión no se pudo establecer.<br />";
die( print_r( sqlsrv_errors(), true));
}
?>
It work fine
but when i try YII
it didnt connect,
my web page freeze and never stop
i’m using this connection script
‘db’=>array(
'connectionString' => 'sqlsrv:Server=200.xxx.xxx.xxx.;Database=test4',
'username' => 'test',
'password' => 'test',
'emulatePrepare' => false,
'charset' => 'utf8',
),
what is wrong???