Hi!
I have very limited experience in UNIX, I have couple questions about database connection in C programs.
I used to use pro*C to setup database connection to a remote Oracle server when I was in school about 2 yrs ago, is this method still in use in commercial C programs nowdays?... (2 Replies)
i want to connect c++ to ms access.
i am not clear about the concept of odbc
please make me clear that for the above connection which version of odbc i will need?
i am working on solaris
so is there any kind like an odbc for windows and odbc for solaris?
form where i can get the odbc... (0 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,
Hi we have application running on Unix Server(solaris10), which establishes connection(sessions) with DATABASE(oracle 10g) which is on another server and firewal is there in between. After some time i am usually getting connection time out(oarcle error 3114/3113) in some of my... (0 Replies)
Hello.
I have to make a script with more than 1 SQL query and the problem is that i have to alternate from sql commands to unix commands.
what i would like to know if it's posible(and how) to keep the databse connection opened till last sql command is ran and execute unix commands while the... (2 Replies)
Hi,
I am touching shell scripting after a long gap of 3 years and forgotten almost all of it.
So need help from everyone to revamp myself.
To begin,please tell me what does this part of script do ( I have been asked to go thru a script and get a feel of it):
#get database connection... (1 Reply)
Good afternoon
i need your help, i am new at unix, in a ETL scenario like datastage is , there are a bunch of procesess (script shells) conecting to hetereogenius database source servers in order to extract information.
Ive got 2 questions
1. Using unix how can i identify exactly the... (1 Reply)
Hi,
How to creating connection to mysql.I try to connect but the following error coming .How to solve it.
Could not connect to New MySQL.
Error creating SQL Model Connection connection to New MySQL. (Error: com.mysql.jdbc.Driver)
com.mysql.jdbc.Driver
Error creating JDBC Connection... (2 Replies)
Hi All.
Does anybody here know the System I database? it's from IBM. because i don't know how to connect on the database using unix. How do i know what parameter will i use?
Thanks, (2 Replies)
Discussion started by: znesotomayor
2 Replies
LEARN ABOUT PHP
pg_lo_open
PG_LO_OPEN(3)PG_LO_OPEN(3)pg_lo_open - Open a large objectSYNOPSIS
resource pg_lo_open (resource $connection, int $oid, string $mode)
DESCRIPTION pg_lo_open(3) opens a large object in the database and returns large object resource so that it can be manipulated.
Warning
Do not close the database connection before closing the large object resource.
To use the large object interface, it is necessary to enclose it within a transaction block.
Note
This function used to be called pg_loopen(3).
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $oid
- The $OID of the large object in the database.
o $mode
- Can be either "r" for read-only, "w" for write only or "rw" for read and write.
RETURN VALUES
A large object resource or FALSE on error.
EXAMPLES
Example #1
pg_lo_open(3) example
<?php
$database = pg_connect("dbname=jacarta");
pg_query($database, "begin");
$oid = pg_lo_create($database);
echo "$oid
";
$handle = pg_lo_open($database, $oid, "w");
echo "$handle
";
pg_lo_write($handle, "large object data");
pg_lo_close($handle);
pg_query($database, "commit");
?>
SEE ALSO pg_lo_close(3), pg_lo_create(3).
PHP Documentation Group PG_LO_OPEN(3)