Thanks for the comments, but I don't think that I made myself clear.
I am connecting using the native PHP pg support. The only bit I'm using ODBC
for is the Windows/Delphi stuff.
BTW, the Delphi app can connect/disconnect as often as it wants, but one
connection from Delphi stops the PHP working.
Gary
On Friday 01 March 2002 2:04 pm, Jean-Michel POURE wrote:
> Le Vendredi 1 Mars 2002 14:28, Gary Stainburn a écrit :
> > Unfortunately, a side effect is that the PHP loses it's connection and
> > returns a 'not valid handle' error message.
>
> PostgreSQL odbc works perfectly. We cannot garantee PHP odbc interface
> works as well... But there is a solution :
>
> PHP supports native connexions to PostgreSQL which is the recommended way.
> Most users choose native connexions from PHP because they :
> - are better supported,
> - have better performance.
>
> If you would like to connect to various databases using PHP, choose an
> abstraction layer. There are many available for PHP : ADODB (ADO port under
> PHP), PEARDB (http://pear.php.net) available from PHP cvs, etc...
>
> Best regards,
> Jean-Michel POURE
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000