Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

ingres_pconnect(3) [php man page]

INGRES_PCONNECT(3)							 1							INGRES_PCONNECT(3)

ingres_pconnect - Open a persistent connection to an Ingres database

SYNOPSIS
resource ingres_pconnect ([string $database], [string $username], [string $password], [array $options]) DESCRIPTION
Open a persistent connection to an Ingres database. There are only two differences between this function and ingres_connect(3): First, when connecting, the function will initially try to find a (persistent) link that is already opened with the same parameters. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the Ingres server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (ingres_close(3) will not close links established by ingres_pconnect(3)). This type of link is therefore called "persistent". PARAMETERS
o $database - The database name. Must follow the syntax: $[vnode::]dbname[/svr_class] o $username - The Ingres user name o $password - The password associated with $username o $options - See ingres_connect(3) for the list of options that can be passed RETURN VALUES
Returns an Ingres link resource on success or FALSE on failure SEE ALSO
ingres_connect(3), ingres_close(3). PHP Documentation Group INGRES_PCONNECT(3)

Check Out this Related Man Page

MSSQL_PCONNECT(3)														 MSSQL_PCONNECT(3)

mssql_pconnect - Open persistent MS SQL connection

SYNOPSIS
resource mssql_pconnect ([string $servername], [string $username], [string $password], [bool $new_link = false]) DESCRIPTION
mssql_pconnect(3) acts very much like mssql_connect(3) with two major differences. First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mssql_close(3) will not close links established by mssql_pconnect(3)). This type of links is therefore called 'persistent'. PARAMETERS
o $servername - The MS SQL server. It can also include a port number. e.g. hostname:port. o $username - The username. o $password - The password. o $new_link - If a second call is made to mssql_pconnect(3) with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned. This parameter modifies this behavior and makes mssql_pconnect(3) always open a new link, even if mssql_pconnect(3) was called before with the same parameters. RETURN VALUES
Returns a positive MS SQL persistent link identifier on success, or FALSE on error. EXAMPLES
Example #1 mssql_pconnect(3) using the $new_link parameter <?php // Connect to MSSQL and select the database $link1 = mssql_pconnect('MANGOSQLEXPRESS', 'sa', 'phpfi'); mssql_select_db('php', $link1); // Create a new link $link2 = mssql_pconnect('MANGOSQLEXPRESS', 'sa', 'phpfi', true); mssql_select_db('random', $link2); ?> PHP Documentation Group MSSQL_PCONNECT(3)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

copy, clear and keep to new data only

I have an Ingres database logfile that grows constantly, iircp.log. It is always "attached" to the Ingres process that uses it, and I do not want to screw up the data. I have been copying it to another directory and then using vi on the original to reduce the size 34000 lines at a time. What I want... (1 Reply)
Discussion started by: sarge
1 Replies

2. UNIX for Dummies Questions & Answers

Moric

Does anyone know if Mote.Moric.org blocks can be opened without the username? (3 Replies)
Discussion started by: needshelP
3 Replies

3. Shell Programming and Scripting

passing oracle parameters back to Shell

Hi All, Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure: eg #username='scott' #password='tiger' #database='orcl' username='ITGCD03D03' password='tC5epIew' database='ITGCD03D' sqlplus -s... (4 Replies)
Discussion started by: satnamx
4 Replies

4. UNIX for Dummies Questions & Answers

database connection failing from linux

Hi, I am trying to connect to an Oracle database using the following code : sqlplus username/password@database_name It was showing an error 'username/password invalid' But i tried: sqlplus username/password ,it was connecting now. Can anyone suggest what may be the... (1 Reply)
Discussion started by: DILEEP410
1 Replies

5. UNIX for Dummies Questions & Answers

to separate values from a string

Hi I would like to take input from user like username/password@connectstring I should be able to cut the username and password and connect string for example if someone enters like sam/sammy@ora1 my program should take sam as username sammy as password and ora1 as connectstring and... (3 Replies)
Discussion started by: ssuresh1999
3 Replies

6. Solaris

Check Database availability?

Hi All, My script gets aborted as it is connecting as a remote database through a DB link on every 3rd sunday.As the remote DB is down for more than 6 hours. Can TNSPING DBNAME inside my script ensure the database is up??? Then how can i check the database is up or down ? ... (2 Replies)
Discussion started by: megh
2 Replies

7. Shell Programming and Scripting

Database Connection test in unix Script

i have a unix script that gives me the sysdate from the database EDNAMID.WORLD.What i want my script to do the following 1) Establish a database connection 2) if database connection is successfull then echo the message "Connected" 3) put the o/p of the Sql query in a spool file 4) then... (3 Replies)
Discussion started by: ali560045
3 Replies

8. Programming

how to obtain a persistent oracle connection in proc*c pthread

Hi all, I have problem to set up a persistent oracle connection in child thread. We have a massive batch process dealing with large data. Application was written and impossible to be rewritten. I am trying to extract the most time consuming data fetching and put it into a dedicated child... (3 Replies)
Discussion started by: ora-dev
3 Replies

9. AIX

Unable to add persistent IP

i am trying to make HACMP but when i add a persistent ip, error shows unable to determine address for 'UPIDGIS1_pers' pls help me out AIX - 5.3 HACMP -5.4 thanks (2 Replies)
Discussion started by: reply.ravi
2 Replies

10. What is on Your Mind?

Why am I persistent to be WRONG!

(2 Replies)
Discussion started by: animesharma
2 Replies

11. Homework & Coursework Questions

Help fixing my database script

1. The problem statement, all variables and given/known data: I need help I get a variant of syntax errors when compiling my script to maintain a database. It's a simple database meant to create/view/maintain vehicles. 2. Relevant commands, code, scripts, algorithms: my if statements have... (5 Replies)
Discussion started by: gamernerd101
5 Replies

12. Shell Programming and Scripting

Need to use another file in script

hi everyone, i making script in KSH AIX server i n which i am calling sql connection, i want password and username stored in another directory and in my script it looks like sqlpus -s $username/$password @eod.sql and my username and password stored in file databaseconnection like this... (2 Replies)
Discussion started by: pallvi_mahajan
2 Replies

13. Shell Programming and Scripting

How to replace a string to asterisk?

Hi, I would like to ask for you idea on how to convert a string to "*". say password and username. I have a shell script that will promt the user to enter username and password. This will be passed to sqlplus command. echo "Please enter user name" read USERNAME echo... (2 Replies)
Discussion started by: reignangel2003
2 Replies

14. Shell Programming and Scripting

Encrypt and decrypt the password in a Shell Script

Hello, I have the following UNIX shell script which connects to the teradata database and executes the SQL Queries. For this, I am passing database name, username and password. I don't want to reveal my password to anyone. So, is there any way that I can encrypt my password and read the... (2 Replies)
Discussion started by: ronitreddy
2 Replies

15. Shell Programming and Scripting

Script for database task.

Hi, I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password. Could you please provide the script for this task? Steps are given below. 1. Login into database from server sqlplus... (5 Replies)
Discussion started by: Maddy123
5 Replies