Hope this helps I figured out the problem. Turns out the web.config file from one of the Java applications was overriding the MVC application's web.config file even though they were running on different app pools. Apparently this was caused by the configuration of the Apache Tomcat connector installed on the server. Moving the connection string to the Java application's web.config file solved the issue temporarily.
PHP MySQL: boolean Value works on local server but returns empty on live server?
wish of those help I had the status value as BIT on my local server which was working fine on the local server however it was returning empty on live server. FIX ON LIVE SERVER: Changed the status column type from BIT to TINYINT on live server.
PHP MySQL Login works on Local Server but not on Public Server