#45849 [Com]: segmentation fault accessing mssql with pdo/odbc

 ID:               45849
 Comment by:       dk at trick dot ca
 Reported By:      dk at trick dot ca
 Status:           Open
 Bug Type:         PDO related
 Operating System: Linux
 PHP Version:      5.2.6
 New Comment:

further investigation shows this error occurs when a field of type
"text" or "varchar(max)" is included in the query.


Previous Comments:
------------------------------------------------------------------------

[2008-08-18 10:08:22] dk at trick dot ca

typo, first line of testpdo.pgp does have a missing quote:

$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD');

------------------------------------------------------------------------

[2008-08-18 10:06:39] dk at trick dot ca

Description:
------------
PHP Segfaults when I query MS SQL Server 2005 via an ODBC DSN with
PDO.
The query returns fine using tsql, and there is nothing wrong in the
freetds log.



Reproduce code:
---------------
(names/credentials changed)

testpdo.php:

<?php
$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD);
foreach ($d->query('SELECT * from MYTABLE') as $row) {
      print_r($row);
}


odbc.ini:

[MYDSN]
Driver = /usr/lib/libtdsodbc.so.0
Description = MYDSN
Trace = Yes
Servername = MYSERVER
Database = MYDATABASE

freetds.conf:

[MYSERVER]
host = MYHOST
port = 1433
tds version = 8.0




Expected result:
----------------
print results or some sort of error.

Actual result:
--------------
# php testpdo.php
Segmentation fault



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=45849&edit=1