|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27077 Changing 'mssql.textsize' in php.ini causes connections to stop working
Submitted: 2004-01-28 12:57 UTC Modified: 2004-01-30 11:13 UTC
From: jason at burfield dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.3.4 OS: Linux ( Suse 9 )
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: jason at burfield dot com
New email:
PHP Version: OS:


 [2004-01-28 12:57 UTC] jason at burfield dot com
PHP, configured as such:

'./configure' '--with-mssql=/usr/local' '--with-apxs=/usr/sbin/apxs' '--with-mcrypt=/usr/local' '--enable-trans-id'

Use Suse 9.0
Using Apache 1.3.28
Using FreeTDS.

I encountered a problem with the 'textsize' and 'textlimit' values in the PHP.INI file when using SQL Server.

If left to their default values (commented out) everything is fine, however, when I change the value to a larger size, in this case up to 10000, Apache starts and all seems fine, however, connecting to the SQL Server database machine stops working.

If I change the limit back to default the connections start working again.

I also attempted changing the settings in freetds.conf, however, that had no effect at all.

Reproduce code:
/* simple connection */
$host = 'server:1433';
$user = 'username';
$pass = 'password';

$dblink = mssql_connect($host, $user, $pass);

This fails when the 'textsize' or 'textlimit' values are changed from defaults.

Expected result:
Expect a connection to the database server to be made.

Actual result:
Connection to database server fails.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-01-29 14:47 UTC] jason at burfield dot com
This latest cvs seems to have helped. PHP now seems to be reading the textsize value from the freetds.conf file as expected, however, I am still running in to problems passing large queries through to SQL Server. (2000)

Thanks for the quick update.
 [2004-01-30 11:13 UTC]
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
Thank you for the report, and for helping us make PHP better.

User reports that the problem has been fixed. 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Jun 24 16:01:32 2024 UTC