Skip to Content.
Sympa Menu

freetds - RE: [freetds] connect problem to mssql 7.0

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] connect problem to mssql 7.0
  • Date: Wed, 10 Dec 2003 17:14:42 +0100

>
> Thanks for our help and effort.
>
> With netstat i can see that they are divers connections to my
> mssql server. If I compare the PID I can see one httpd id is
> equal to one connection to my mssql server on port 1433
>
> That means php open a new connection to the new PID from httpd.
>
> > When first process finish connections are automatically closed... or
> > not ??
> I think so,
>
> i can not reproduce the error, with my testscript, because the error
> occurred without any system. (I can see anyone)
>

I don't follow you...

> after a restart the apache it works fine, and the connections closed
> automatically.
>
> what should I do to get a stable connection?
>
>
> Roland
>
>

PHP speaks about persistent connections... I don't know how to fix your
problem however in every script you use you have to use mssql_pconnect
to get a valid connection. Do not expect to use the connection id (the
mssql_pconnect result) in another script.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page