PHP ODBC conflict

Поиск
Список
Период
Сортировка
Искать

PHP ODBC conflict

От:
Gary Stainburn <gary.stainburn@ringways.co.uk>
Дата:
Hi all,

I've got a web server using PHP with a persistant connection to my database, 
and this works fine.

I'm experimenting with Delphi and the latest ODBC drivers that I got from 
http://odbc.postgresql.org.  While I'm very impressed with this version - the 
last version I tried was a few years ago - it is causing me some problems.

When I use the ODBC to connect to my database, the Delphi App works fine - 
just as expected.  

Unfortunately, a side effect is that the PHP loses it's connection and 
returns a 'not valid handle' error message.

Has anyone got any ideas why this is happening, and what I can do about it.

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

Re: PHP ODBC conflict

От:
Jean-Michel POURE <jm.poure@freesurf.fr>
Дата:
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

Re: PHP ODBC conflict

От:
Gary Stainburn <gary.stainburn@ringways.co.uk>
Дата:
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     

Re: PHP ODBC conflict

От:
Jean-Michel POURE <jm.poure@freesurf.fr>
Дата:
Le Vendredi 1 Mars 2002 15:40, Gary Stainburn a écrit :
> 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

Dear Gary,

The best place to post your question is pgsql-odbc@postgresql.org, and I am 
sending a copy of your mail there. / Jean-Michel
------------------------------------------------------------
Hi all,

I've got a web server using PHP with a persistant connection to my database, 
and this works fine.

I'm experimenting with Delphi and the latest ODBC drivers that I got from 
http://odbc.postgresql.org.  While I'm very impressed with this version - the 
last version I tried was a few years ago - it is causing me some problems.

When I use the ODBC to connect to my database, the Delphi App works fine - 
just as expected.  

Unfortunately, a side effect is that the PHP loses it's connection and 
returns a 'not valid handle' error message.

Has anyone got any ideas why this is happening, and what I can do about it.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: PHP ODBC conflict

От:
Zak Greant <zak@mysql.com>
Дата:
On Fri, 2002-03-01 at 08:06, Jean-Michel POURE wrote:
> Le Vendredi 1 Mars 2002 15:40, Gary Stainburn a écrit :
> > 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
> 
> Dear Gary,
> 
> The best place to post your question is pgsql-odbc@postgresql.org, and I am 
> sending a copy of your mail there. / Jean-Michel
> ------------------------------------------------------------

  Dear Gary,

  IMO this is likely a problem that is related to PHP rather than PG
  or ODBC. Perhaps check the PHP-General and PHP-DB mailing list
  archives (see http://www.php.net/support.php). Please also check the
  list of bugs at http://bugs.php.net/

  If you don't spot the problem somewhere else, please submit a bug
  report. If you are newer to PHP and feel that you may have made a
  coding error, please post to the PHP General or PHP DB mailing lists
  to get some help and feedback. http://www.php.net/support.php has
  information on how to subscribe and on alternate sources of help.

  --

  Zak Greant

  MySQL Advocate
  PHP QA Team

FAQ