Skip to Content.
Sympa Menu

freetds - RE: [freetds] Multiple Active Statements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Multiple Active Statements
  • Date: Tue, 23 Sep 2003 14:57:54 +0200

>
> I have:
> Mandrake 9.1
> Apache 2.0.44
> PHP 4.3.1
> FreeTDS 0.61
> unixODBC 2.2.4
>
> Can i use multiple active statements?
>
> In PHP when i try this code:
> <?
> ...
> $rs1 = odbc_exec($idconn,$sql1);
> $rs2 = odbc_exec($idconn,$sql2); <--- error
> ...
> ?>
>
> I obtain this error:
> Warning: SQL error: [unixODBC][Driver Manager]Option
> value changed, SQL state 01S02 in SQLExecDirect
>
> How can I solve this problem?
> Thanks,
> Dario
>

Use two connections.
This is a SQL Server (both Sybase and Microsoft) limit.
Future versions will support cursors (another workaround)

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page