Re: IBM DB2 on Linux with PHP is very slow
| From: | Glenn Butcher | Date: | Mon, 16 Jul 2001 22:00:51 +0000 |
| Subject: | Re: IBM DB2 on Linux with PHP is very slow | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10478@lists.php.net to get a copy of this message | ||
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 in
/home/butcher/public_html/php/service_portal/content.php(68)
: eval()'d code online 56
msg: [IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00
The SQLSTATE pretty well says it all - I've been through the
CLI docs and all the words indicate that this cursortype
isn't supported. Side note: according to the IBM docs,
SQLSetConnectOption is deprecated in favor of SQLSetSQLAttr
or some such...
Anyone have any clues? I'm using DB2 V7.1.
Regards,
Glenn Butcher
PS - I sent a similar query last week; my identity wasn't
properly configured and my reply-to address went out as an
IP address - my apologies.