Thread: PHP ODBC conflict
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
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
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
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
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