• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help?

#1
Using bare php with the pdo odbc connection method, and having the DB2 connector installed, I can connect and query just fine, using this DSN:

odbcBig GrinRIVER={iSeries};SYSTEM=localhost;PROTOCOL=TCPIP;DATABASE=TEST

Using the same DSN in Codeigniter, with pdo, I am apparently able to connect, but any time I run any queries, I get 0 results when I should be getting many, and also find that the query itself seems to be having the parameters removed from it (if I echo last_query they appear empty).

Can anybody shed some light on what I or CI is doing wrong? At this point I'm not sure which it is.

I know that DB2 can be odd, but since I've prototyped the functionality in vanilla php that I'm looking to replicate in Codeigniter, I suspect I'm missing something subtle in my configuration, or that something is broken in the codeigniter code.

Any and all help is appreciated. Thanks!
Reply

#2
Ok, so even loading up the class I wrote, that works in vanilla php, in CI, I am making the connection, but still getting 0 results.

Does CI do something under the hood, or overload some native php functions that would cause this?
Reply

#3
It appears that my parameters are being replaced with empty ticks ... ''

Seems to be a bug?
Reply

#4
https://github.com/bcit-ci/CodeIgniter/issues/4084
Reply

#5
hello mpdmp,

How you configure your codeigniter to accesto DB2 IBM pleeeeease ?
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2017 MyBB Group.