#47073 [Bgs]: don�t connect to mssql

ID: 47073 User updated by: joao dot rebelo at pchouse dot pt Reported By: joao dot rebelo at pchouse dot pt Status: Bogus Bug Type: MSSQL related Operating System: Windows XP SP3 PHP Version: 5.2.8 New Comment: Ok. Thanks, it was the php_pdo_mysql that was not loaded, only php_mssql was loaded. Now is working. Previous Comments: ------------------------------------------------------------------------ [2009-01-12 15:36:19] pajoye@php.net Well, the error is clear. You did not install the mssql driver. But as we are not Zend and has little to do with the Zend framework, I would suggest to ask for some support there instead. Not a php bug > bogus. ------------------------------------------------------------------------ [2009-01-12 15:28:35] joao dot rebelo at pchouse dot pt function datamssql(){ if(!$mssqldb){ global $mssql_host, $mssql_user, $mssql_password, $mssql_database; $mssqldb = new Zend_Db_Adapter_Pdo_Mssql(array( 'host' => $mssql_host, 'username' => $mssql_user, 'password' => $mssql_password, 'dbname' => $mssql_database )); } return $mssqldb; } // end mssql connection Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'The mssql driver is not currently installed' in C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php:103 Stack trace: #0 C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Mssql.php(135): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Abstract.php(389): Zend_Db_Adapter_Pdo_Mssql->_connect() #2 C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php(205): Zend_Db_Adapter_Abstract->query('SELECT COUNT(no...', Array) #3 C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\backoffice\wintouch\subfamilia.class.php(351): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(no...') #4 C:\wamp\virtualhost\pchousecms\cmsadmin\include\connector\subfamilia\subfamilia.php(16): subfamilia->countrec() #5 {main} thrown in C:\wamp\virtualhost\pchousecms\cmsadmin\include\Zend\Db\Adapter\Pdo\Abstract.php on line 103 I also had copy the ntwdblib.dll as i did in on PHP 5.2.6 to work, but doesn´t work ------------------------------------------------------------------------ [2009-01-12 10:35:39] pajoye@php.net Please show us some script. Also the driver from Microsoft is not compatible with PHP's mssql drivers. They use differenet APIs. ------------------------------------------------------------------------ [2009-01-12 10:15:23] joao dot rebelo at pchouse dot pt Description: ------------ Upgrading from PHP 5.2.6 to PHP 5.2.8 and had stopping the connection with MSSQL, with the message 'no driver installed' even after installing the driver from Microsoft web site and installing and configure php.ini to load the drive when I rollback to PHP 5.2.6 everything works fine. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47073&edit=1