#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: No Feedback
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
Assigned To: felipe
New Comment:
My Modification:
static int pdo_dblib_handle_factory(pdo_dbh_t *dbh, zval
*driver_options TSRMLS_DC)
{
pdo_dblib_db_handle *H;
int i, ret = 0;
char *location = L=;
struct pdo_data_src_parser vars[] = {
{ charset,NULL, 0 },
{ appname,PHP PDO_DBLIB_FLAVOUR, 0 },
{ host, 127.0.0.1, 0 },
{ dbname, NULL, 0 },
{ secure, NULL, 0 }, /* DBSETLSECURE */
/* TODO: DBSETLVERSION ? */
};
php_pdo_parse_data_source(dbh-data_source, dbh-data_source_len,
vars, 5);
H = pecalloc(1, sizeof(*H), dbh-is_persistent);
H-login = dblogin();
H-err.sqlstate = dbh-error_code;
if (!H-login) {
strcat(location, login);
goto cleanup;
}
if (dbh-username) {
DBSETLUSER(H-login, dbh-username);
}
if (dbh-password) {
DBSETLPWD(H-login, dbh-password);
}
#if !PHP_DBLIB_IS_MSSQL
if (vars[0].optval) {
DBSETLCHARSET(H-login, vars[0].optval);
}
#endif
DBSETLAPP(H-login, vars[1].optval);
#if PHP_DBLIB_IS_MSSQL
dbprocerrhandle(H-login, (EHANDLEFUNC) error_handler);
dbprocmsghandle(H-login, (MHANDLEFUNC) msg_handler);
#endif
H-link = dbopen(H-login, vars[2].optval);
if (H-link == NULL) {
strcat(location, link);
goto cleanup;
}
/* dblib do not return more than this length from text/image */
DBSETOPT(H-link, DBTEXTLIMIT, 2147483647);
/* limit text/image from network */
DBSETOPT(H-link, DBTEXTSIZE, 2147483647);
if (vars[3].optval FAIL == dbuse(H-link, vars[3].optval)) {
strcat(location, optval);
goto cleanup;
}
ret = 1;
dbh-max_escaped_char_length = 2;
dbh-alloc_own_columns = 1;
cleanup:
for (i = 0; i sizeof(vars)/sizeof(vars[0]); i++) {
if (vars[i].freeme) {
efree(vars[i].optval);
}
}
dbh-methods = dblib_methods;
dbh-driver_data = H;
if (!ret) {
zend_throw_exception_ex(php_pdo_get_exception(), 0 TSRMLS_CC,
SQLSTATE[%s] %s (severity %d) %s, //I want to
findout the bug
location !
DBLIB_G(err).sqlstate,
DBLIB_G(err).dberrstr,
DBLIB_G(err).severity,
location);
}
return ret;
}
The PDO MSSQL work is correct, the bug never happen and never throws
any PDOException after Complie php_pdo_mssql.dll ...
I think my modification STOP all PDOException throw ...
Anyone can tell me what is the problem ?
Previous Comments:
[2009-09-17 01:00:02] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to Open.
[2009-09-10 15:38:07] Rockyjl at gmail dot com
apache 2.2.13 + PHP 5.2 (5.2.11RC3-dev) VC6 x86 Thread Safe
(2009-Sep-10 12:00:00)
often happen error:
[2009-09-10 23:30:10]
127.0.0.1
ApacheBench/2.3
SQLSTATE[] (null) (severity 0)
This patch cannot work ???!!!
[2009-09-10 06:07:50] Rockyjl at gmail dot com
PHP 5.3 (5.3.2-dev) VC6 x86 Thread Safe (2009-Sep-10 06:00:00)
http://windows.php.net/downloads/snaps/php-5.3-win32-VC6-x86-latest.zip
the bug happen too
[2009-09-10 01:20:42] s...@php.net
Automatic comment from SVN on behalf of felipe
Revision: http://svn.php.net/viewvc/?view=revisionrevision=288215
Log: - Possible fix for bug #49344 on Windows (pdo_mssql fails to
connect,throws PDOException SQLSTATE[] (null) (severity 0))
[2009-09-09 09:43:20] Rockyjl at gmail dot com
Pajoye, Thank you so much! This is very important to me !
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/49344
--
Edit
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Feedback
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
Assigned To: felipe
New Comment:
PHP 5.3 (5.3.2-dev) VC6 x86 Thread Safe (2009-Sep-10 06:00:00)
http://windows.php.net/downloads/snaps/php-5.3-win32-VC6-x86-latest.zip
the bug happen too
Previous Comments:
[2009-09-10 01:20:42] s...@php.net
Automatic comment from SVN on behalf of felipe
Revision: http://svn.php.net/viewvc/?view=revisionrevision=288215
Log: - Possible fix for bug #49344 on Windows (pdo_mssql fails to
connect,throws PDOException SQLSTATE[] (null) (severity 0))
[2009-09-09 09:43:20] Rockyjl at gmail dot com
Pajoye, Thank you so much! This is very important to me !
[2009-09-09 08:21:07] paj...@php.net
Felipe, if you feel like your patch is correct, pls apply it. The next
snap will have it.
Let me know if you prefer to provide a test DLL prior to commit. I can
build one later today.
[2009-09-09 07:16:50] Rockyjl at gmail dot com
I don't how to NMAKE source... Anyone can help me NMake the
php_pdo_mssql.dll and php_pdo.dll with this
Index: ext/pdo_dblib/dblib_driver.c
===
--- ext/pdo_dblib/dblib_driver.c(revisão 288156)
+++ ext/pdo_dblib/dblib_driver.c(cópia de trabalho)
@@ -231,9 +231,7 @@
}
#if PHP_DBLIB_IS_MSSQL
- if (DBSETOPT(H-link, DBTEXTLIMIT, 2147483647) == FAIL) {
- goto cleanup;
- }
+ DBSETOPT(H-link, DBTEXTSIZE, 2147483647);
#endif
if (vars[3].optval FAIL == dbuse(H-link, vars[3].optval)) {
thank you so much !
[2009-09-08 11:33:56] fel...@php.net
Hi, Can you try this patch in 5.2.11-dev?
http://felipe.c2zlabs.com/diff/bug49344.diff
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/49344
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Feedback
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
Assigned To: felipe
New Comment:
apache 2.2.13 + PHP 5.2 (5.2.11RC3-dev) VC6 x86 Thread Safe
(2009-Sep-10 12:00:00)
often happen error:
[2009-09-10 23:30:10]
127.0.0.1
ApacheBench/2.3
SQLSTATE[] (null) (severity 0)
This patch cannot work ???!!!
Previous Comments:
[2009-09-10 06:07:50] Rockyjl at gmail dot com
PHP 5.3 (5.3.2-dev) VC6 x86 Thread Safe (2009-Sep-10 06:00:00)
http://windows.php.net/downloads/snaps/php-5.3-win32-VC6-x86-latest.zip
the bug happen too
[2009-09-10 01:20:42] s...@php.net
Automatic comment from SVN on behalf of felipe
Revision: http://svn.php.net/viewvc/?view=revisionrevision=288215
Log: - Possible fix for bug #49344 on Windows (pdo_mssql fails to
connect,throws PDOException SQLSTATE[] (null) (severity 0))
[2009-09-09 09:43:20] Rockyjl at gmail dot com
Pajoye, Thank you so much! This is very important to me !
[2009-09-09 08:21:07] paj...@php.net
Felipe, if you feel like your patch is correct, pls apply it. The next
snap will have it.
Let me know if you prefer to provide a test DLL prior to commit. I can
build one later today.
[2009-09-09 07:16:50] Rockyjl at gmail dot com
I don't how to NMAKE source... Anyone can help me NMake the
php_pdo_mssql.dll and php_pdo.dll with this
Index: ext/pdo_dblib/dblib_driver.c
===
--- ext/pdo_dblib/dblib_driver.c(revisão 288156)
+++ ext/pdo_dblib/dblib_driver.c(cópia de trabalho)
@@ -231,9 +231,7 @@
}
#if PHP_DBLIB_IS_MSSQL
- if (DBSETOPT(H-link, DBTEXTLIMIT, 2147483647) == FAIL) {
- goto cleanup;
- }
+ DBSETOPT(H-link, DBTEXTSIZE, 2147483647);
#endif
if (vars[3].optval FAIL == dbuse(H-link, vars[3].optval)) {
thank you so much !
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/49344
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Feedback
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
Assigned To: felipe
New Comment:
I don't how to NMAKE source... Anyone can help me NMake the
php_pdo_mssql.dll and php_pdo.dll with this
Index: ext/pdo_dblib/dblib_driver.c
===
--- ext/pdo_dblib/dblib_driver.c(revisão 288156)
+++ ext/pdo_dblib/dblib_driver.c(cópia de trabalho)
@@ -231,9 +231,7 @@
}
#if PHP_DBLIB_IS_MSSQL
- if (DBSETOPT(H-link, DBTEXTLIMIT, 2147483647) == FAIL) {
- goto cleanup;
- }
+ DBSETOPT(H-link, DBTEXTSIZE, 2147483647);
#endif
if (vars[3].optval FAIL == dbuse(H-link, vars[3].optval)) {
thank you so much !
Previous Comments:
[2009-09-08 11:33:56] fel...@php.net
Hi, Can you try this patch in 5.2.11-dev?
http://felipe.c2zlabs.com/diff/bug49344.diff
[2009-09-08 09:37:12] Rockyjl at gmail dot com
Apache/2.2.13 (Win32) PHP/5.2.11RC3-dev
Error:
[2009-09-08 17:34:13]
127.0.0.1
ApacheBench/2.3
SQLSTATE[] (null) (severity 0)
Help !!! Who can help me ? please !
[2009-09-03 09:26:14] rockyjl at gmail dot com
web server is Apache 2.2.11 and Apache 2.2.13 x86 no_ssl
[2009-08-27 08:27:57] rockyjl at gmail dot com
php-5.2.11RC2-dev-win32-VC6-x86 has the Bug too!
Anyone can help me ? Please !
[2009-08-25 02:08:48] rockyjl at gmail dot com
I upgrade to php-5.2.11RC2-dev-win32-VC6-x86 now !
Testing the bug
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/49344
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Feedback
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
Assigned To: felipe
New Comment:
Pajoye, Thank you so much! This is very important to me !
Previous Comments:
[2009-09-09 08:21:07] paj...@php.net
Felipe, if you feel like your patch is correct, pls apply it. The next
snap will have it.
Let me know if you prefer to provide a test DLL prior to commit. I can
build one later today.
[2009-09-09 07:16:50] Rockyjl at gmail dot com
I don't how to NMAKE source... Anyone can help me NMake the
php_pdo_mssql.dll and php_pdo.dll with this
Index: ext/pdo_dblib/dblib_driver.c
===
--- ext/pdo_dblib/dblib_driver.c(revisão 288156)
+++ ext/pdo_dblib/dblib_driver.c(cópia de trabalho)
@@ -231,9 +231,7 @@
}
#if PHP_DBLIB_IS_MSSQL
- if (DBSETOPT(H-link, DBTEXTLIMIT, 2147483647) == FAIL) {
- goto cleanup;
- }
+ DBSETOPT(H-link, DBTEXTSIZE, 2147483647);
#endif
if (vars[3].optval FAIL == dbuse(H-link, vars[3].optval)) {
thank you so much !
[2009-09-08 11:33:56] fel...@php.net
Hi, Can you try this patch in 5.2.11-dev?
http://felipe.c2zlabs.com/diff/bug49344.diff
[2009-09-08 09:37:12] Rockyjl at gmail dot com
Apache/2.2.13 (Win32) PHP/5.2.11RC3-dev
Error:
[2009-09-08 17:34:13]
127.0.0.1
ApacheBench/2.3
SQLSTATE[] (null) (severity 0)
Help !!! Who can help me ? please !
[2009-09-03 09:26:14] rockyjl at gmail dot com
web server is Apache 2.2.11 and Apache 2.2.13 x86 no_ssl
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/49344
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: Rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Open
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
New Comment:
Apache/2.2.13 (Win32) PHP/5.2.11RC3-dev
Error:
[2009-09-08 17:34:13]
127.0.0.1
ApacheBench/2.3
SQLSTATE[] (null) (severity 0)
Help !!! Who can help me ? please !
Previous Comments:
[2009-09-03 09:26:14] rockyjl at gmail dot com
web server is Apache 2.2.11 and Apache 2.2.13 x86 no_ssl
[2009-08-27 08:27:57] rockyjl at gmail dot com
php-5.2.11RC2-dev-win32-VC6-x86 has the Bug too!
Anyone can help me ? Please !
[2009-08-25 02:08:48] rockyjl at gmail dot com
I upgrade to php-5.2.11RC2-dev-win32-VC6-x86 now !
Testing the bug
[2009-08-24 10:06:51] rockyjl at gmai dot com
Description:
in Bug #48539
[28 Jun 2:10am UTC] fel...@php.net
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Fixed in 5.2 and HEAD.
5.3 in soon.
Thanks.
But the bug still often happen in PHP 5.2.11RC1 ...
Could you tell me which version(win32 zip) can work in the environment
of win2003 x64 + apache 2.2.11 + sql2005,and the pdo_mssql can connect
DB successfully ??
Reproduce code:
---
function db()
{
try
{
$db = new PDO(DB_DSN, DB_User, DB_Password);
return $db;
}
catch (PDOException $e)
{
die($e-getMessage());
}
}
Expected result:
connect DB Successful
Actual result:
--
SQLSTATE[] (null) (severity 0)
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Open
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
New Comment:
web server is Apache 2.2.11 and Apache 2.2.13 x86 no_ssl
Previous Comments:
[2009-08-27 08:27:57] rockyjl at gmail dot com
php-5.2.11RC2-dev-win32-VC6-x86 has the Bug too!
Anyone can help me ? Please !
[2009-08-25 02:08:48] rockyjl at gmail dot com
I upgrade to php-5.2.11RC2-dev-win32-VC6-x86 now !
Testing the bug
[2009-08-24 10:06:51] rockyjl at gmai dot com
Description:
in Bug #48539
[28 Jun 2:10am UTC] fel...@php.net
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Fixed in 5.2 and HEAD.
5.3 in soon.
Thanks.
But the bug still often happen in PHP 5.2.11RC1 ...
Could you tell me which version(win32 zip) can work in the environment
of win2003 x64 + apache 2.2.11 + sql2005,and the pdo_mssql can connect
DB successfully ??
Reproduce code:
---
function db()
{
try
{
$db = new PDO(DB_DSN, DB_User, DB_Password);
return $db;
}
catch (PDOException $e)
{
die($e-getMessage());
}
}
Expected result:
connect DB Successful
Actual result:
--
SQLSTATE[] (null) (severity 0)
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Open
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
New Comment:
php-5.2.11RC2-dev-win32-VC6-x86 has the Bug too!
Anyone can help me ? Please !
Previous Comments:
[2009-08-25 02:08:48] rockyjl at gmail dot com
I upgrade to php-5.2.11RC2-dev-win32-VC6-x86 now !
Testing the bug
[2009-08-24 10:06:51] rockyjl at gmai dot com
Description:
in Bug #48539
[28 Jun 2:10am UTC] fel...@php.net
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Fixed in 5.2 and HEAD.
5.3 in soon.
Thanks.
But the bug still often happen in PHP 5.2.11RC1 ...
Could you tell me which version(win32 zip) can work in the environment
of win2003 x64 + apache 2.2.11 + sql2005,and the pdo_mssql can connect
DB successfully ??
Reproduce code:
---
function db()
{
try
{
$db = new PDO(DB_DSN, DB_User, DB_Password);
return $db;
}
catch (PDOException $e)
{
die($e-getMessage());
}
}
Expected result:
connect DB Successful
Actual result:
--
SQLSTATE[] (null) (severity 0)
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#49344 [Com]: pdo_mssql fails to connect,throws PDOException SQLSTATE[] (null) (severity 0)
ID: 49344
Comment by: rockyjl at gmail dot com
Reported By: rockyjl at gmai dot com
Status: Open
Bug Type: PDO related
Operating System: win2003 X64
PHP Version: 5.2.11RC1
New Comment:
I upgrade to php-5.2.11RC2-dev-win32-VC6-x86 now !
Testing the bug
Previous Comments:
[2009-08-24 10:06:51] rockyjl at gmai dot com
Description:
in Bug #48539
[28 Jun 2:10am UTC] fel...@php.net
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Fixed in 5.2 and HEAD.
5.3 in soon.
Thanks.
But the bug still often happen in PHP 5.2.11RC1 ...
Could you tell me which version(win32 zip) can work in the environment
of win2003 x64 + apache 2.2.11 + sql2005,and the pdo_mssql can connect
DB successfully ??
Reproduce code:
---
function db()
{
try
{
$db = new PDO(DB_DSN, DB_User, DB_Password);
return $db;
}
catch (PDOException $e)
{
die($e-getMessage());
}
}
Expected result:
connect DB Successful
Actual result:
--
SQLSTATE[] (null) (severity 0)
--
Edit this bug report at http://bugs.php.net/?id=49344edit=1
#38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field
ID: 38805
Comment by: rockyjl at gmail dot com
Reported By: gkrajci at arescorporation dot com
Status: Assigned
Bug Type: PDO related
Operating System: Windows NT PBMA-WB2 5.2 build 37
PHP Version: 5.1.6
Assigned To: wez
New Comment:
why can't fix in php 5.2.5 this is very importance for developer
!
Previous Comments:
[2007-09-11 08:36:42] rockyjl at gmail dot com
ini_set('mssql.textlimit', '65536');
ini_set('mssql.textsize', '65536');
it is work for php_mssql.dll
but not work for php_pdo_mssql.dll
how can i get more than 4096 byte in TEXT with php_pdo_mssql.dll ???
[2007-08-13 19:22:32] jagwire16 at hotmail dot com
http://us3.php.net/manual/en/function.mssql-query.php#64470 reports how
to make it work and that solution worked for me.
[2007-02-14 16:16:49] matt at educause dot edu
I too can reproduce this problem ... a critical hurdle for us.
[2006-12-06 14:50:17] frank at interlevel dot com
Seems I am not alone on this. I have also tried altering the PHP.ini
with no result. IS there an update to this PDO?
[2006-11-08 14:30:06] mark dot pearson at capita dot co dot uk
I have found the same problem with PHP 5.1.6 running on Windows XP Pro
SP2 and MS SQL Server 2000 (using the pdo_mssql driver).
I also tried to solve it by setting the mssql.textlimit and
mssql.textsize INI options, since that used to cause the same problem in
the mssql extension but it doesn't have any effect on the values
returned by PDO.
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/38805
--
Edit this bug report at http://bugs.php.net/?id=38805edit=1
#38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field
ID: 38805
Comment by: rockyjl at gmail dot com
Reported By: gkrajci at arescorporation dot com
Status: Assigned
Bug Type: PDO related
Operating System: Windows NT PBMA-WB2 5.2 build 37
PHP Version: 5.1.6
Assigned To: wez
New Comment:
why can't fix in php 5.2.5 this is very importance for developer
!
Previous Comments:
[2007-11-17 03:15:08] rockyjl at gmail dot com
why can't fix in php 5.2.5 this is very importance for developer
!
[2007-09-11 08:36:42] rockyjl at gmail dot com
ini_set('mssql.textlimit', '65536');
ini_set('mssql.textsize', '65536');
it is work for php_mssql.dll
but not work for php_pdo_mssql.dll
how can i get more than 4096 byte in TEXT with php_pdo_mssql.dll ???
[2007-08-13 19:22:32] jagwire16 at hotmail dot com
http://us3.php.net/manual/en/function.mssql-query.php#64470 reports how
to make it work and that solution worked for me.
[2007-02-14 16:16:49] matt at educause dot edu
I too can reproduce this problem ... a critical hurdle for us.
[2006-12-06 14:50:17] frank at interlevel dot com
Seems I am not alone on this. I have also tried altering the PHP.ini
with no result. IS there an update to this PDO?
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/38805
--
Edit this bug report at http://bugs.php.net/?id=38805edit=1
#38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field
ID: 38805
Comment by: rockyjl at gmail dot com
Reported By: gkrajci at arescorporation dot com
Status: Assigned
Bug Type: PDO related
Operating System: Windows NT PBMA-WB2 5.2 build 37
PHP Version: 5.1.6
Assigned To: wez
New Comment:
ini_set('mssql.textlimit', '65536');
ini_set('mssql.textsize', '65536');
it is work for php_mssql.dll
but not work for php_pdo_mssql.dll
how can i get more than 4096 byte in TEXT with php_pdo_mssql.dll ???
Previous Comments:
[2007-08-13 19:22:32] jagwire16 at hotmail dot com
http://us3.php.net/manual/en/function.mssql-query.php#64470 reports how
to make it work and that solution worked for me.
[2007-02-14 16:16:49] matt at educause dot edu
I too can reproduce this problem ... a critical hurdle for us.
[2006-12-06 14:50:17] frank at interlevel dot com
Seems I am not alone on this. I have also tried altering the PHP.ini
with no result. IS there an update to this PDO?
[2006-11-08 14:30:06] mark dot pearson at capita dot co dot uk
I have found the same problem with PHP 5.1.6 running on Windows XP Pro
SP2 and MS SQL Server 2000 (using the pdo_mssql driver).
I also tried to solve it by setting the mssql.textlimit and
mssql.textsize INI options, since that used to cause the same problem in
the mssql extension but it doesn't have any effect on the values
returned by PDO.
[2006-09-26 16:22:57] ritch at bugsoftware dot co dot uk
I'm also suffering this problem after changing my database connection
type to PDO.
I'm running PHP 5.1.2 on Windows server 2003 with MSSQL 2005.
In the old mssql ext. you had to specificaly tell the configure it in
php.ini to bring back larger text fields:
; Valid range 0 - 2147483647. Default = 4096.
mssql.textlimit = 2147483647
; Valid range 0 - 2147483647. Default = 4096.
mssql.textsize = 2147483647
I have not found the same for the new PDO extension - so I'm assuming
this has some thing to do with the problem. (My text fields are also
truncated to 4096)
Help with this issue would be greatley appreciated.
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/38805
--
Edit this bug report at http://bugs.php.net/?id=38805edit=1
