Re: Connection of postgres - Mailing list pgsql-odbc

From Nguyen, Lam Thuy
Subject Re: Connection of postgres
Date
Msg-id C3D5057033EDF145B90A99CD9025BFEA01C601FB@hont05.fcg.com
Whole thread Raw
In response to get number of rows selected  ("Malm Paul" <paul.malm@saabgroup.com>)
Responses Re: Connection of postgres  (Andrei Kovalevski <andyk@commandprompt.com>)
List pgsql-odbc
yes, it is right.

________________________________

From: Andrei Kovalevski [mailto:andyk@commandprompt.com]
Sent: Sun 4/6/2008 9:35 PM
To: Nguyen, Lam Thuy
Cc: Malm Paul; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Connection of postgres



Hello,

Does it happen after some idle period?

Nguyen, Lam Thuy wrote:
> Hey,
>
> I have a problem with connection of postgres.
> I am using postgres 8.03.01.
>
> I have a telecom program which have 248 channels and each channel hold a connection to postgres database, mean i have
248opening connections. 
>
> When a channel is run, it means it begin to excute some queries to postgres, i got the error :  SQL Error State:
08S01
>
>                                     Native Error Code: 1A
>
>                                     ODBC Error:        Could not send
> Query(connection dead);
>
>                           Could not send Query(connection dead)
>
>
> Could you help me on this ?
>
>
> Thanks you very much
> Lam
>
>
>
>
>
>
> This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of
theintended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited.  If you are not the intended recipient, please contact the sender and delete all copies. 
>
>


--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/




This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the
intendedrecipient.  Any review, reliance, or distribution by others or forwarding without express permission is
strictlyprohibited.  If you are not the intended recipient, please contact the sender and delete all copies. 

pgsql-odbc by date:

Previous
From: Andrei Kovalevski
Date:
Subject: Re: Connection of postgres
Next
From: Andrei Kovalevski
Date:
Subject: Re: get number of rows selected