note 36342 added to ref.mssql
| From: | duarte at uma dot pt | Date: | Mon, 06 Oct 2003 15:44:18 +0000 |
| Subject: | note 36342 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-57898@lists.php.net to get a copy of this message | ||
SQLServer 2000 (win2k) and PHP 4.3.3 + FreeTDS 0.61.1 (SuSE 7.3)
I coulnd't connect to SQLServer 2000 after compiling PHP 4.3.3 with FreeTDS 0.61.
But I had in the same machine PHP 4.2.3 + FreeTDS 0.61 and it was working fine.
I found in a freetds mailing list that PHP now set mssql.textsize and mssql.textlimit, so, to get
PHP 4.3.3 connecting with MSSQL 2000 with FreeTDS 0.61 we should comment out the following lines in
PHP.INI:
;mssql.textlimit= xxxx
;mssql.textsize= xxxx
I have compiled FreeTDS --with-tdsver=7.0 --enable-msdblib
and PHP --with-mssql=/usr/local/freetds
More details in: http://lists.ibiblio.org/pipermail/freetds/2003q3/013323.html
I hope this helps somebody because I spent 2 days to solve this "problem"... ;-)
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+36342
Delete -- http://master.php.net/manage/user-notes.php?action=delete+36342&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+36342&report=yes
Search -- http://master.php.net/manage/user-notes.php