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

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

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

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

Christian, Are you using an ODBC driver or just the unified-ODBC functions? If a driver, then I suggest changing vendors - that performance is in no way representative of ODBC in general. In addition, to improve performance even more when using similar queries, first use odbc_prepare to prepare a

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

ODBC access to DB/2 works just fine via PHP. For a HOWTO on enabling ODBC in PHP, see www.iodbc.org. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com > -Orig

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

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