iAnywhere
                  North America  [Change]
Home | Events | Downloads | Partners | Developers | Contact Us
CompanySolutionsServices & SupportOur CustomersHow to Buy

sqlanywhere_pconnect


Prototype

resource sqlanywhere_pconnect( string con_str )
Description
Establishes a persistent connection to an Adaptive Server Anywhere database. Because of the way Apache creates child processes, you may observe a performance gain when using sqlanywhere_pconnect instead of sqlanywhere_connect. Persistent connections may provide improved performance in a similar fashion to connection pooling. If your database server has a limited number of connections (for example, the personal database server is limited to 10 concurrent connections), caution should be exercised when using persistent connections. Persistent connections could be attached to each of the child processes, and if you have more child processes in Apache than there are available connections, you will receive connection errors.
Parameters
con_str      A connection string as recognized by Adaptive Server Anywhere.
Returns
A positive SQL Anywhere persistent link identifier on success, or an error and 0 on failure.
Example
This example passes the user ID and password for an Adaptive Server Anywhere database in the connection string.

$conn = sqlanywhere_pconnect( "UID=dba;PWD=sql" );

Related functions
sqlanywhere_connect
sqlanywhere_disconnect

Back to Top

    
 ©Copyright 2008 iAnywhere Solutions, Inc.