INGRES_PCONNECT(3) 1 INGRES_PCONNECT(3)ingres_pconnect - Open a persistent connection to an Ingres databaseSYNOPSIS
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 connectionSYNOPSIS
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)