ODBC

[eluser]Unknown[/eluser]
I had the same error. after hours and hours i got it work in the following way:

1. go to the system\database\drivers\odbc\odbc_driver.php and comment out the whole function CI_DB_odbc_driver($params) line 51 to line 56 -> this seems to be a bug in the constructor.

2. do not use statements like (foreach $query->result() as $row){ echo $row->ID;} ... use instead (foreach $query->result_array() as $row){ echo $row['ID'];} this works for me.

3. i don't exactly know if there's another mistake within codeigneter or php with odbc. i can't use $query->num_rows(). this always gives back -1 no matter if there's a record selected or not. i use instead a seperate counter like $count = 0; foreach (....){count++;}

hope i could help you, 'cause i was sitting for about 2 days on that problem but now it works.

Chris