#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:
typo, first line of testpdo.pgp does have a missing quote:
$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD');
Previous Comments:
[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=45849edit=1
#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=45849edit=1
#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:
Possibly related to 41399?
http://bugs.php.net/bug.php?id=41888
Previous Comments:
[2008-08-18 11:28:21] dk at trick dot ca
further investigation shows this error occurs when a field of type
text or varchar(max) is included in the query.
[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=45849edit=1
