ID: 13722
Updated by: [EMAIL PROTECTED]
Reported By: brendan at msu dot edu
Status: No Feedback
Bug Type: Sybase-ct (ctlib) related
Operating System: Solaris 2.7
PHP Version: 4.2.1
New Comment:
Make sure you set TDS Version to 7 or 8. You can do this in
freetds.conf where you define your server connection.
Previous Comments:
------------------------------------------------------------------------
[2006-09-05 09:21:36] hostmak at gmail dot com
problem still exists....ideas ? :|
------------------------------------------------------------------------
[2002-09-14 01:00:01] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, 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".
------------------------------------------------------------------------
[2002-08-13 23:41:55] [EMAIL PROTECTED]
updating version as well.
------------------------------------------------------------------------
[2002-08-13 23:41:36] [EMAIL PROTECTED]
try doing a "SET TEXTSIZE <some really large number here>" in an exec
command.
------------------------------------------------------------------------
[2002-07-26 23:42:43] systematic11 at comcast dot net
As of version 4.2.1, this issue has still not been corrected. Perhaps
the problem lies with FreeTDS.
Apparently neither the CT-Lib and DB-Lib for Sybase have no use for
this property (MSSQL TEXT SIZE).
If you must connect to MS SQL Server from PHP, I would suggest creating
an include file that is included at the top of any PHP script that needs
to access the MS SQL Server. Let the include file open a connection and
call a query to "set textsize 65536" or to whatever limit you want.
e.g.
<?php
// include file for MS SQL server
$HOSTNAME = "SQLServer70";
$USERNAME = "sa";
$PASSWORD = "??";
$conn = mssql_pconnect($HOSTNAME, $USERNAME, $PASSWORD);
if ($conn) {
mssql_query("SET TEXTSIZE 65536");
mssql_select_db("whatever", $conn);
}
?>
Kelly Akins
------------------------------------------------------------------------
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/13722
--
Edit this bug report at http://bugs.php.net/?id=13722&edit=1
