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:
odbc
RIVER={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!