Re: [PHP-DB] IBM DB2

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 far,

Re: [PHP-DB] IBM DB2

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 far,

Re: [PHP-DB] IBM DB2

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 far

Re: [PHP-DB] IBM DB2

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 qu

[PHP-DB] IBM DB2

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 --

Re: [PHP-DB] IBM DB2 and php

Gerard Samuel wrote: example script | // 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); odbc_binmode($result, 0); // Trying to retrieve 2nd row out of 6

[PHP-DB] IBM DB2 and php

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 changin

Re: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

Matt Schroebel wrote: Gerard Samuel 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 foun

RE: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

Gerard Samuel 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

[PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

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, the

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

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 i

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

I just tried the Cursortype parameter (apache-1.3.20+php-4.0.6, DB2-7.1), but I get this message: Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in /home/butcher/public_html/php/service_portal/content.php(68) : eval()'d co

Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow

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 t

RE: [PHP-DB] IBM DB2 on Linux with PHP is very slow

ders > -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

[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? 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: It

Re: [PHP-DB] ibm db2

Yup, there's been PHP support for DB2 on Linux for quite some time. Use the --with-ibm-db2[=name] configure option when you build PHP. Then use the Unified ODBC PHP functions and you're rocking. Under the covers PHP uses DB2's native CLI interface, so it's quite fast. (By the way, IBM has been

RE: [PHP-DB] ibm db2

> -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.

[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 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: [EM

Re: [PHP-DB] IBM DB2 connectction problems

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 webserver

Re: [PHP-DB] IBM DB2 connectction problems

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 4.0.3

RE: [PHP-DB] IBM DB2 connectction problems

7 AM To: [EMAIL 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.

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 easy to tell, what the problem is. Well, as I posted, my SQL error is null and state is r

Re: [PHP-DB] IBM DB2 connectction problems

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; > SER

[PHP-DB] IBM DB2 connectction problems

Hi! I have a problem with connection to IBM DB2 database. I have a Linux (Mandrake 7.2) machine with apache 1.3.14 (from distribution), DB2 V7.1 installed (trial) and self-made php 4.0.3pl1 module, compiled with --with-ibm-db2. When I put in script: $i = odbc_connect ("PROTOCOL=TCPIP; SERVE

Re: [PHP-DB] IBM DB2 and DSN

Hi. On Thu, Jan 04, 2001 at 12:17:50PM -0800, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > I failed twice so I just added another entry to the catalog. If you > > know how to delete an entry in the catalog please tell me. The manual > > was to hard to lookup for the solution. > > You can "d