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