[eluser]whobutsb[/eluser]
So I wanted to make a reply on this thread because I finally found out what the issue was. The issue was when I made a query on Database X and then made query on Database Y and then back to Database X the CI wasn't sending the "USE Database X" command. So instead of using loading the database in the constructor of the model I added the the load->database() method into the individual model functions. This makes it so that CI changes the database every single time.
This was a seriously confusing bug. I had to use the SQL Server Profiler application to find this out.
Quick question to the CI community:
If in the Database config file if I changed the pconnect option to TRUE, would this solve the issue?
Thanks for the help!