FreeTDS / PHP 3.0.16 Fails on Large Insert

Rusty Conover rconover at zootweb.com
Wed Aug 2 16:06:06 EDT 2000



Brian,

I've fixed this problem by setting the TCP_NODELAY flag with setsockopt() when
I open the TDS connection.  After I set that socket option flag everything works
with large queries.

Rusty


On Wed, 02 Aug 2000 14:00:04 Brian Bruns wrote:
> This is a problem with TDS 7.0 with queries that cross the block size (512
> bytes by default).  I could fix it if someone will send me a network dump
> of the packets, otherwise I'll have to set up a test and do it myself
> which I won't be able to get to for some time.
> 
> Brian
> 
> On Wed, 2 Aug 2000, Jon McDonald wrote:
> 
> > On MSSQL 7.0 we have a nvarchar field set to 2048 bytes.  The following PHP

> > code fails:
> > 
> > <?
> > //$query = "INSERT INTO bi..test (test) 
> > VALUES('1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111!
!
1111111111111111111111111111111111
> > $id = mssql_connect("sqlbox", "username", "password");
> > $result = mssql_query($query, $id);
> > mssql_close($id);
> > ?>
> > 
> > The 1's are repeated 1024 times.
> > 
> > Any suggestions would be appreciated.  Network sniffs show the data being 
> > sent to the SQL Server from the PHP box.  However, the data is never 
> > inserted into SQL and no error message is returned...
> > 
> > 
> > Thanks in Advance!
> > 
> > ---
> > You are currently subscribed to freetds as: camber at ais.org
> > To unsubscribe, forward this message to
$subst('Email.Unsub')
> > 
> > 
> 
> 
> ---
> You are currently subscribed to freetds as: rconover at zootweb.com
> To unsubscribe, forward this message to
$subst('Email.Unsub')
> 

-- 
---------------------------------------------
Rusty Conover        | rusty at zootweb.com 
Systems Programmer   | 406-586-5050 x242
Zoot Enterprises     | http://www.zootweb.com
---------------------------------------------




More information about the FreeTDS mailing list