Robert Twitty wrote:
On Thu, 19 Aug 2004, Gerard Samuel wrote:
Robert Twitty wrote:
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So
Robert Twitty wrote:
On Thu, 19 Aug 2004, Gerard Samuel wrote:
Robert Twitty wrote:
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So far, ODBTP
performs quite well with IBM DB2 in regards to regular queries.
-- bob
--
Robert Twitty wrote:
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So far, ODBTP
performs quite well with IBM DB2 in regards to regular
Maybe in early August, I got my code to work with DB2 8.1.3 via ODBC
after a bit of teeth pulling.
I played with it for about 2-3 weeks, and it seemed ok (slow but ok).
Earlier this past week, I was modifying the DB drivers for my script,
and now, DB2 refuses to cooperate.
I don't remember
Gerard Samuel wrote:
example script
|?php
||// contains db connection stuff|
|include('include.php');
// body is a text field
$sql = 'select id, user_id, name, time, body, ip from NULLID.guestbook
for read only';
$result = odbc_exec($db-_connection_id, $sql);
odbc_longreadlen($result, 0);
For the most part, I got my code running with IBM DB2 8.1.3
But its slower than dirt. Maybe 1 out of 10 times, a page would exceed
the 30 second time limit.
I understand on a fresh database startup, it takes time to get things
together to run.
But sometimes it would seem like its going fast,
Gerard Samuel mailto:[EMAIL PROTECTED] wrote on Tuesday, August 19,
2003 2:32 PM:
I understand on a fresh database startup, it takes time to get things
together to run. But sometimes it would seem like its going fast, then
othertimes, crawl
slower than snails.
I've found that, with an
Matt Schroebel wrote:
Gerard Samuel mailto:[EMAIL PROTECTED] wrote on Tuesday, August 19,
2003 2:32 PM:
understand on a fresh database startup, it takes time to get things
together to run. But sometimes it would seem like its going fast, then
othertimes, crawl
slower than snails.
I've found
I'm experiencing slowness in the fetching of result sets. I
set the cursortype parameter as suggested by Christian
Szardenings to SQL_CUR_USE_ODBC, and I get the following:
Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not
capable. SQLSTATE=S1C00, SQL state S1C00 in
SQLSetConnectOption
-Original Message-
From: news.php.net [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 5:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] IBM DB2 on Linux with PHP is very slow
Hi,
does someone has a DB2 UDB from IBM working with
PHP in a production envirement ? How is the performance
Hi Andrew,
thanks a lot for your help. Today we discovered what
our real problem was:
After playing a little bit with the php-scripts that try
to connect to the IBM DB2, we set the optional parameter
Cursortype when calling odbc_pconnect().
And the exciting thing: When we set the cursor
Hi,
does someone has a DB2 UDB from IBM working with
PHP in a production envirement ? How is the performance?
For a relaunch of our existing production system running
on IBM DB2 on serveral IBM RS/6000 servers we tested
the performance of connecting PHP to this database.
And what can I say:
Hi All,
I've noticed that IBM is making its DB2 database available
for Linux platforms. Does anyone know if there will be PHP
support for it?
Thank you,
Mike Wright
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
-Original Message-
From: Mike Wright [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 1:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] ibm db2
Hi All,
I've noticed that IBM is making its DB2 database available
for Linux platforms. Does anyone know if there will be PHP
support
I think it's more likely that you haven't sourced the
/home/db2inst1/sqllib/db2profile script in whatever wrapper script starts
up Apache for you. Add the following line to the top of 'apachectl' or
'/etc/rc.d/init.d/httpd' to set up the DB2 environment variable before you
start your
PROTECTED]
Subject: Re: [PHP-DB] IBM DB2 connectction problems
hello,
$i = odbc_connect( "sample", "db2inst1", "ibmdb2" );
I changed, but got same (= none) result.
Please provide more detailed information on the SQL error and SQL state.
Otherwise it is not really
OK, here are some important details about my system:
1. Linux (Mandrake 7.2)
2. Apache 1.3.14 (from distribution)
3. jre118 (rpm, IBM version)
4. IBM DB2 V7.1
Installed with default logins, directories, etc.
5. Added '/usr/IBMdb2/V7.1/lib' to '/etc/ld.so.conf'; 'ldconfig' executed
6. PHP
Hi,
It should read:
$i = odbc_connect( "sample", "db2inst1", "ibmdb2" );
Please provide more detailed information on the SQL error and SQL state.
Otherwise it is not really easy to tell, what the problem is.
ManieQ wrote:
$i = odbc_connect ("PROTOCOL=TCPIP; SERVERNAME=jajo.tpi.pl;
19 matches
Mail list logo
