Re: [PHP-DB] obdc_pconnect problems
Have you tried with alternate drivers? Either way, you can capture an ODBC trace to see what is going on. The odbc.ini should have an entry for tracing that you can uncomment. Best regards, Andrew Hill OpenLink Software. On Friday, July 26, 2002, at 03:25 AM, Escuder Nicolas wrote: Hello, i don't use the cgi version i compile php with --with-apache :o) and the connection seem to be exist with netstat each time i use the web script, it reconnect and open a new tcp and let the previous open ... See you Nicolas. - Original Message - From: Andrew Hill [EMAIL PROTECTED] To: 'Escuder Nicolas' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:34 PM Subject: RE: [PHP-DB] obdc_pconnect problems Nicolas, I believe the _pconnect functions all close connections if you close the script - they are most useful when you have multiple connections in a single page. Also, are you using the CGI version of PHP? Pconnects are not persistent with this version. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Escuder Nicolas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] obdc_pconnect problems Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] obdc_pconnect problems
Hello, i don't use the cgi version i compile php with --with-apache :o) and the connection seem to be exist with netstat each time i use the web script, it reconnect and open a new tcp and let the previous open ... See you Nicolas. - Original Message - From: Andrew Hill [EMAIL PROTECTED] To: 'Escuder Nicolas' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 7:34 PM Subject: RE: [PHP-DB] obdc_pconnect problems Nicolas, I believe the _pconnect functions all close connections if you close the script - they are most useful when you have multiple connections in a single page. Also, are you using the CGI version of PHP? Pconnects are not persistent with this version. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Escuder Nicolas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] obdc_pconnect problems Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] obdc_pconnect problems
Nicolas, I believe the _pconnect functions all close connections if you close the script - they are most useful when you have multiple connections in a single page. Also, are you using the CGI version of PHP? Pconnects are not persistent with this version. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Escuder Nicolas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] obdc_pconnect problems Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] obdc_pconnect problems
Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas.
[PHP-DB] obdc_pconnect problems
Hello, i use php as not a cgi it is include in my apache my odbc is a custom odbc driver so i try to use odbc_pconnect, the first time it connect to the db i saw the connection tcp by netstat and the next time (on the next page) i reuse pconnect with the same db user pass and sql cursor but it open a new connection, i see two connection with netstat ... and more connection if i go another page ... i don't understand why ... see you nicolas.