Edit report at http://bugs.php.net/bug.php?id=49344&edit=1
ID: 49344 Comment by: tom at punkave dot com Reported by: rockyjl at gmai dot com Summary: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0) Status: No Feedback Type: Bug Package: PDO related Operating System: win2003 X64 PHP Version: 5.2.11RC1 Assigned To: felipe Block user comment: N Private report: N New Comment: Works with the command line tsql tool even though it does not work with command line PHP. Both using the FreeTDS that was installed on PHP's behalf. Previous Comments: ------------------------------------------------------------------------ [2011-04-11 18:47:33] tom at punkave dot com Still experiencing this error. Tweaking freetds.conf: [global] # TDS protocol version # Microsoft compatible we hope tds version = 7.0 Had no effect. PHP 5.3.5 (cli) (built: Jan 27 2011 11:42:56) on macports. ------------------------------------------------------------------------ [2011-01-07 09:37:47] wrobel at wsb-nlu dot edu dot pl It seems that the problem is solved by changing tds version to 7.0 instead of 8.0 in freetds configuration... ------------------------------------------------------------------------ [2011-01-06 12:11:45] wrobel at wsb-nlu dot edu dot pl I have the same problem when connecting: PDOException with message SQLSTATE[] (null) (severity 0). My environment is: PHP 5.2.14 apache-2.2.16 Sql Server 2008 Express (and Sql Server 2008 R2) Linux/PLD ------------------------------------------------------------------------ [2009-10-09 18:56:19] s...@php.net Automatic comment from SVN on behalf of pajoye Revision: http://svn.php.net/viewvc/?view=revision&revision=289440 Log: - Possible fix for bug #49344 on Windows (pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)) ------------------------------------------------------------------------ [2009-10-07 09:14:41] philipp at servicemail24 dot de The same error occurs using Ubuntu 0910 with Zend Framework: require_once('Zend/Db.php'); $db = Zend_Db::factory('Pdo_Mssql', array( 'host' => 'sqlsrv', 'username' => 'php', 'password' => 'secret', 'dbname' => 'myDatabase', 'pdoType' => 'dblib' )); $result = $db->fetchAll(SELECT * FROM MyTable"); var_dump($result); Zend_Db_Adapter_Exception: SQLSTATE[] (null) (severity 0) in /usr/share/php/libzend-framework-php/Zend/Db/Adapter/Pdo/Abstract.php on line 144 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=49344 -- Edit this bug report at http://bugs.php.net/bug.php?id=49344&edit=1