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
> 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
> > executed
> > $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw);
> > it happens very often that a new connection is created instead of
> > the old one!
> > Is there any idea what's wrong... ?
> > And another question - when user hits reload or submit button at the
> > when
> > actually this odbc_pconnect is in progress - it generates another
> > 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
> > 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
> > 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