Re: [PHP] odbc_pconnect doesnt reuse connection
Why won't you just use odbc_connect ? - Original Message - From: Maris Kalnins [EMAIL PROTECTED] To: Sent: Wednesday, April 03, 2002 3:07 AM Subject: [PHP] odbc_pconnect doesnt reuse connection Hi! Configuration: WinXP, the latest Apache, PHP4 The problem is that every time the script runs and the following command is executed $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); it happens very often that a new connection is created instead of reusing the old one! Is there any idea what's wrong... ? And another question - when user hits reload or submit button at the moment when actually this odbc_pconnect is in progress - it generates another connection leaving the old one (half opened or whatever) still alive.. So if you will click on submit button more than 10 times with a little short interval - we will get ODBC error - Database server connection limit exceeded I tried to set in PHP config file odbc.max_persistent = 1 but it still overgoes more than 1 connection to the same database, user and password.. What's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] odbc_pconnect doesnt reuse connection
because odbc_connect takes some time to establish connection while odbc_pconnect establishes it once after that it suppose to give faster access through already existing connection! that's what I got from php manual.. the bad thing is .. that in reality it works a little bit different.. so I am wondering .. why? Eric Coleman [EMAIL PROTECTED] wrote in message 026b01c1db1c$860b2890$0201a8c0@devstation">news:026b01c1db1c$860b2890$0201a8c0@devstation... Why won't you just use odbc_connect ? - Original Message - From: Maris Kalnins [EMAIL PROTECTED] To: Sent: Wednesday, April 03, 2002 3:07 AM Subject: [PHP] odbc_pconnect doesnt reuse connection Hi! Configuration: WinXP, the latest Apache, PHP4 The problem is that every time the script runs and the following command is executed $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); it happens very often that a new connection is created instead of reusing the old one! Is there any idea what's wrong... ? And another question - when user hits reload or submit button at the moment when actually this odbc_pconnect is in progress - it generates another connection leaving the old one (half opened or whatever) still alive.. So if you will click on submit button more than 10 times with a little short interval - we will get ODBC error - Database server connection limit exceeded I tried to set in PHP config file odbc.max_persistent = 1 but it still overgoes more than 1 connection to the same database, user and password.. What's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] odbc_pconnect doesnt reuse connection
I have an IDEA If your familiar with OOP Write a class that is like a WRAPPER to the ODBC functions. Then, you can connect once, and keep the connection ALL this using just odbc_connect This is what I have done, and if you would like, I can write a quick one. Eric - Original Message - From: Maris Kalnins [EMAIL PROTECTED] To: Sent: Wednesday, April 03, 2002 10:11 AM Subject: Re: [PHP] odbc_pconnect doesnt reuse connection because odbc_connect takes some time to establish connection while odbc_pconnect establishes it once after that it suppose to give faster access through already existing connection! that's what I got from php manual.. the bad thing is .. that in reality it works a little bit different.. so I am wondering .. why? Eric Coleman [EMAIL PROTECTED] wrote in message 026b01c1db1c$860b2890$0201a8c0@devstation">news:026b01c1db1c$860b2890$0201a8c0@devstation... Why won't you just use odbc_connect ? - Original Message - From: Maris Kalnins [EMAIL PROTECTED] To: Sent: Wednesday, April 03, 2002 3:07 AM Subject: [PHP] odbc_pconnect doesnt reuse connection Hi! Configuration: WinXP, the latest Apache, PHP4 The problem is that every time the script runs and the following command is executed $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); it happens very often that a new connection is created instead of reusing the old one! Is there any idea what's wrong... ? And another question - when user hits reload or submit button at the moment when actually this odbc_pconnect is in progress - it generates another connection leaving the old one (half opened or whatever) still alive.. So if you will click on submit button more than 10 times with a little short interval - we will get ODBC error - Database server connection limit exceeded I tried to set in PHP config file odbc.max_persistent = 1 but it still overgoes more than 1 connection to the same database, user and password.. What's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] odbc_pconnect doesnt reuse connection
Hi! Configuration: WinXP, the latest Apache, PHP4 The problem is that every time the script runs and the following command is executed $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); it happens very often that a new connection is created instead of reusing the old one! Is there any idea what's wrong... ? And another question - when user hits reload or submit button at the moment when actually this odbc_pconnect is in progress - it generates another connection leaving the old one (half opened or whatever) still alive.. So if you will click on submit button more than 10 times with a little short interval - we will get ODBC error - Database server connection limit exceeded I tried to set in PHP config file odbc.max_persistent = 1 but it still overgoes more than 1 connection to the same database, user and password.. What's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] odbc_pconnect doesnt reuse connection
Hi! Configuration: WinXP, the latest Apache, PHP4 The problem is that every time the script runs and the following command is executed $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw); it happens very often that a new connection is created instead of reusing the old one! Is there any idea what's wrong... ? And another question - when user hits reload or submit button at the moment when actually this odbc_pconnect is in progress - it generates another connection leaving the old one (half opened or whatever) still alive.. So if you will click on submit button more than 10 times with a little short interval - we will get ODBC error - Database server connection limit exceeded I tried to set in PHP config file odbc.max_persistent = 1 but it still overgoes more than 1 connection to the same database, user and password.. What's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
