PHP and FreeTDS problem

Brian Bruns camber at ais.org
Mon Oct 11 13:35:07 EDT 1999


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



More information about the FreeTDS mailing list