freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Brian Bruns <camber AT ais.org>
- To: 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 16:00:04 -0400 (EDT)
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('111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111')";
> $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
> leave-freetds-12294M AT franklin.oit.unc.edu
>
>
-
FreeTDS / PHP 3.0.16 Fails on Large Insert,
Jon McDonald, 08/02/2000
- <Possible follow-up(s)>
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Brian Bruns, 08/02/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Rusty Conover, 08/02/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Steven Campbell, 08/02/2000
- RE: FreeTDS / PHP 3.0.16 Fails on Large Insert, Franck Martin, 08/02/2000
- RE: FreeTDS / PHP 3.0.16 Fails on Large Insert, James Cameron, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Daniel Bruce Lynes, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Rusty Conover, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, James Cameron, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Rusty Conover, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Brian Bruns, 08/03/2000
- Re: FreeTDS / PHP 3.0.16 Fails on Large Insert, Brian Bruns, 08/03/2000
Archive powered by MHonArc 2.6.24.