Skip to Content.
Sympa Menu

freetds - Re: [freetds] [ freetds-Patches-731907 ] Choosing datalength whenbinding fixed types

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [ freetds-Patches-731907 ] Choosing datalength whenbinding fixed types
  • Date: Mon, 5 May 2003 06:42:35 -0400

On Sun, 4 May 2003 20:05:16 -0000, "Arnar Birgisson" <arnarb AT oddi.is>
wrote:
> CREATE procedure sp_save_persistentdata
> @data varchar(2048)
> as
> -- $Id: sp_save_persistentdata.sql,v 1.1 2003/05/02 22:22:09 arnarb
> Exp $
>
> update kerfisnotendur set persistent_data = @data
> where username = user
> go
>
> and I call it from PHP 4.3.2RC2 linked with FreeTDS 0.61 (with your
> modified patch applied) with this:
>
> $var = "some base-64 encoded data";
> $stm = mssql_init("sp_save_persistentdata", $conn);
> mssql_bind($stm, "@data", $var, SQLVARCHAR, false, false, 0);
> mssql_execute($stm,true);
>
> This works fine as long as the string $var is not longer than about 400
> characters, as soon as it gets larger I start getting "Stored procedure
> execution failed" from PHP. I stepped through mssql_execute in the PHP
> source and it correctly calls dbrpcexec, which returns SUCCESS, and then
> immediately calls dbsqlok which returns FAIL. Stepping throught dbsqlok
> reveals that an "end token" is read from sql server and the call to
> tds_process_end returns a failure code. I didn't go any further than
> that, except for checking the SQL server logs, which for this operation
> contain this:
>
> 2003-05-04 11:46:37.37 ods Error: 17805, Severity: 18, State: 3
> 2003-05-04 11:46:37.37 ods Invalid buffer received from client..
>
> Any ideas on how to proceed?

Arnar,

I would be interested in seeing the TDSDUMP log for your session. It
should be possible to see from it what's wrong with what FreeTDS sent to
your server.

The mailing list restricts attachments to 75 KB. You can either trim the
log or post it as a patch to source forge.

Hälsingar,

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page