Skip to Content.
Sympa Menu

freetds - Re: FreeTDS / PHP 3.0.16 Fails on Large Insert

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rusty Conover <rconover AT zootweb.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Cc: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS / PHP 3.0.16 Fails on Large Insert
  • Date: Wed, 2 Aug 2000 14:06:06 -0600



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
---------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page