+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: PDO:odbc vs Active Record (/showthread.php?tid=54639)
PDO:odbc vs Active Record - El Forum - 09-18-2012
[eluser]Marcky[/eluser]
Hi guys,
I'm wondering if CI's 2.1.2 Active Record Class fully supports PDO functions when using odbc driver.
I'm working with two different databases: local mysql for managing users and and external mdb file.
After some testing outside CI, I managed to load the right driver, connect and made selects and inserts sucessfully to that mdb database. But the trouble comes trying to use the Active Record's functionalities against mdb via PDO: simple queries like select_max() and insert() do not work properly.
At this point I don't need joins or more complicated clauses, but what can I expect if so? I don't think using plain php and pdo::odbc inside my models is a good approach, actually it's what CI's tries to avoid, isn't it?
So, what do you think is the best solution for this case? Am I missing any documentation or concepts?
I'd like to hear from you, more experienced CI developers.