Hi
The settings are as follows:
uodbc.allow_persistent = Off
uodbc.check_persistent = Off
uodbc.max_persistent = -1
We aren't using persistant connections of any type (my manager would prefer
not to I have been told).
Here is an example of how we connect to the database:
// now connect to database...
$db_connection = odbc_connect("localhost:KBUKEN", "xxx",
"xxx");
if ($db_connection)
{
// let's replace the version string which is
currently version="" with the value
// obtained from the database....
$query1 = "SELECT version FROM kb_system";
$rs1 = odbc_exec($db_connection, $query1);
while( odbc_fetch_row($rs1) == true)
{
$version_string =
'version="'.odbc_result($rs1,"version").'"';
}
}
odbc_Close($db_connection);
Any help is appreciated!!
Thanks
Liam.
----- Original Message -----
From: "mordicus" <[EMAIL PROTECTED]>
To: "Liam" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 9:39 PM
Subject: Re: SAP DB and conn pool with PHP
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> Hi,
>
>
> What is your setting for php ? specially
> uodbc.allow_persistent , uodbc.check_persistent , uodbc.max_persistent
?
>
>
>
>
>
> Le Mardi 26 Mars 2002 17:07, vous avez �crit :
> > Hi
> >
> > We have been using SAP DB and ODBC fine within PHP environment
(Linux)...
> >
> > We are now running into bottlenecks and we would like to implement
> > connection pooling using ODBC.
> >
> > Has this been done yet? Is there an easy way to do it?
> >
> > Is Sap DB comatible with other products (SQLRelay unixODBC) which
(claim)
> > to provide these facilities?
> >
> > Thanks
> >
> > Liam.
> > ---------------------------------------------------------------------
> > http://www.textverts.com - [EMAIL PROTECTED]
> > Absolutely free and Direct 2ur Mobile Phone -
> > FREE Ringtones, Logos, SMS!!!
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
