From:             jason at burfield dot com
Operating system: Linux ( Suse 9 )
PHP version:      4.3.4
PHP Bug Type:     MSSQL related
Bug description:  Changing 'mssql.textsize' in php.ini  causes connections to stop 
working

Description:
------------
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.

-- 
Edit bug report at http://bugs.php.net/?id=27077&edit=1
-- 
Try a CVS snapshot (php4):  http://bugs.php.net/fix.php?id=27077&r=trysnapshot4
Try a CVS snapshot (php5):  http://bugs.php.net/fix.php?id=27077&r=trysnapshot5
Fixed in CVS:               http://bugs.php.net/fix.php?id=27077&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=27077&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=27077&r=needtrace
Need Reproduce Script:      http://bugs.php.net/fix.php?id=27077&r=needscript
Try newer version:          http://bugs.php.net/fix.php?id=27077&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=27077&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=27077&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=27077&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=27077&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=27077&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27077&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=27077&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=27077&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=27077&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=27077&r=float

Reply via email to