problem with codeigniter using odbc database driver
- by Nir Gavish
i’ve run into a curious problem with codeigniter's odbc driver.
i’m connecting from a linux machine to an MSSQL 2008 machine using FreeTDS.
while i get that the ‘num_rows’ function always returns -1, and that is fully a database/driver issue - for some reason when i try to create a -result(), the whole application crashes (error 500, sometimes just a blank page), if i’m lucky, i get an error message informing me that the application died because it tried to allocated 2 terrabytes of memory(!).
This happens irregularly, ie: every few refreshes. sometimes it runs fine, sometimes the page returns error 500 and sometimes it gives the memory allocation error - in any case it’s not really something that can be reproduced with percision, and the queries are SUPER simple.
ideas anyone?
