3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9) +--- Thread: 3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? (/showthread.php?tid=62801) |
3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - mpdmp - 08-27-2015 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: odbcRIVER={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! RE: 3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - mpdmp - 08-28-2015 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? RE: 3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - mpdmp - 08-28-2015 It appears that my parameters are being replaced with empty ticks ... '' Seems to be a bug? RE: 3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - mpdmp - 08-28-2015 https://github.com/bcit-ci/CodeIgniter/issues/4084 RE: 3.0 Stable and DB2 - Bare PHP Works with ODBC, CI Is Not...help? - nhakkari - 04-06-2017 hello mpdmp, How you configure your codeigniter to accesto DB2 IBM pleeeeease ? |