Unix Technical Forum

unable to get result data using php

This is a discussion on unable to get result data using php within the DB2 forums, part of the Database Server Software category; --> Hello all, I am connecting to DB2 v. 8.1.4 using PHP 4.3.4 under Linux. The connection is local. I ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:00 PM
Florian Heckl
 
Posts: n/a
Default unable to get result data using php

Hello all,

I am connecting to DB2 v. 8.1.4 using PHP 4.3.4 under Linux. The
connection is local.
I can connect to the database, I can execute at least SELECT statements
(haven't tried others), but I cannot access the results of the query no
matter if I use odbc_fetch_into, odbc_fetch_array, odbc_fetch_row.

But strangely I can get the result set count using odbc_num_rows.
Somehow DB2 seems to not handle the PHP connection as a CLI connection
because tracing is switched on for CLI. I verified that tracing works by
successfully compiling and running the supplied sample CLI apps.

The above scenario is for the ESE version of DB2. I have a second
machine running the Personal Developer's Edition of DB2 and everything
works fine there. There's almost no difference in the configurations.

Any suggestion? Anyone seen this before?
TIA for any help
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:29 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com