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
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
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);
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
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
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
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
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;
14 matches
Mail list logo