Skip to Content.
Sympa Menu

freetds - Re: PHP and FreeTDS problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: PHP and FreeTDS problem

Chronological Thread  
    < Chronological >       < Thread >
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds
  • Subject: Re: PHP and FreeTDS problem
  • Date: Mon, 11 Oct 1999 13:35:7

On 10/11/99, ""Tasos Angelis" <tangelis AT tasos.gr>" wrote:

Ok, one more thing. Are you using --with-sybase or --with-sybase-ct?

> You can try a mssql_close or not.
> The effect is just the same.
> The php manual also says that when a script finishes, the connection
> is closed, even if you are not using a mssql_close, in the case of a
> persistent
> connection.
> In the case of a persistent connection the mssql_close does not closes
> the connection. http://www.php.net/manual/function.mssql-close.php3
>
> But I used all the combinations. Persistent, no persistent, with mssql_cl=
> ose
> or not, but the effect is the same.
>
> Tasos Angelis.
>
> -----Original Message-----
> From: Brian Bruns <camber AT umcc.ais.org>
> To: TDS Development Group <freetds AT franklin.oit.unc.edu>
> Date: =C4=E5=F5=F4=DD=F1=E1, 11 =CF=EA=F4=F9=E2=F1=DF=EF=F5 1999 2:16 =EC=
> =EC
> Subject: [freetds] Re: PHP and FreeTDS problem
>
>
> >
> >Forgive me if I'm just not seeing it, but there is no mssql_close() to
> >close the connection when done.
> >
> >Cheers,
> >
> >Brian
> >
> >On Mon, 11 Oct 1999, Tasos Angelis wrote:
> >
> >> >Can you post a small script demonstrating the problem so I can try to
> >> >replicate it here?
> >>
> >>
> >> Yes of course.
> >> The script follows. I use the persisten connection in it.
> >> I also used it with standard connection.
> >> I forget to say that I use the 0.47beta version of FreeTDS.
> >> The Artists table has got 2 columns. An integer and a varchar(50).
> >>
> >> The script follows:
> >>
> >> <html>
> >> <body>
> >> <center>
> >> <table>
> >> <tr><td colspan=3D2>PlayList from Tempo</td></tr>
> >> <?
> >> ignore_user_abort(1);
> >> $res=3Dmssql_pconnect("tasosa","tempo","tempo");
> >> if(!$res):
> >> ?>
> >> <tr><td colspan=3D2>Could not connect to Tempo</td></tr>
> >>
> >> <?
> >> ELSE:
> >> $what=3Dmssql_select_db("Tempo",$res);
> >> $what=3Dmssql_query("select * from Artists",$res);
> >>
> >> list($id,$name)=3Dmssql_fetch_array($what);
> >>
> >> while($id):
> >> echo "<tr><td>$id</td><td>$name</td></tr>";
> >>
> >> list($id,$name)=3Dmssql_fetch_row($what);
> >> endwhile;
> >> endif;
> >> ?>
> >> </table>
> >> </body>
> >> </html>
> >>
> >
> >


Archive powered by MHonArc 2.6.24.

Top of Page