QUESTION
========
I'm running PHP 3.11 on Win NT 4.0 and using ODBC to connect to a
MSsql-server 6.5 DB.
When I'm selecting a column of datatype text where the size is more than
4096 bytes the php.exe is hanging until it is killed. This happens exactly
when PHP is trying to fetch the value that is bigger than 4096 bytes. All
values ut to 4096 bytes is working fine.
Are there some configurations parameters where I could set this max size ?
ANSWER
======
In php3.ini there are 2 parameters you can change:
mssql.textsize = 4096
mssql.textlimit = 4096
(Trish)
How to connect to MS SQL 6.x+ database server via ODBC functions of
PHP3 compiled with iODBC and Openlink drivers under Linux. Categories : Databases , MS SQL Server , PHP , ODBC Mssql database Manager Categories : PHP , Databases , MS SQL Server , Classes and Objects , PHP Classes Guestbook sort by descending date and can view page by page Categories : PHP , MS SQL Server , Databases Convert SQL from oracle,mysql,mssql,sqlite and odbc to SQL compatible Categories : PHP , PHP Classes , Databases , MySQL , MS SQL Server Simple class for accessing databases like MSSql Server, Oracle etc by Raju Categories : PHP , MS SQL Server , Databases , PHP Classes , Oracle Recordset Class for MSSQL database Categories : PHP Classes , Databases , PHP , MS SQL Server Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0. Categories : Databases , PHP , mSQL , Databases [PHP5] aDB PDO LIKE Database Abstraction. Switch easily from one db server to another, strong errors management, manage transactions, queries preparation and more. Categories : PHP , PHP Classes , Databases , MS SQL Server , MySQL Scripts to build APACHE - PHP and SQL 7.0 Categories : PHP , Databases , MS SQL Server This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases , MySQL , Complete Programs , PHP , Databases An SQL Administration User Interface for the Web Categories : Databases , PHP , mSQL , Complete Programs StoredProcedure, Stored Procedure, Oracle, OCI8, OCI8i Categories : OCI8 , Oracle , Databases , PHP A very simple and efficient split bar the B-Z bar , for mysql and php ...
Tired of obfuscated code try this one ...
Categories : PHP , Databases , MySQL , Algorithms normalize fields and strings used in where (command's Sql) Categories : PHP , Databases , Oracle , Functions Dynamic WHERE CLAUSE depending on number of FORM FIELDS Categories : ODBC , General SQL , PHP , Complete Programs , Databases