CodeIgniter Forums
CI 2.1.4 + MS SQL 2012 - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: CodeIgniter 2.x (https://forum.codeigniter.com/forumdisplay.php?fid=18)
+--- Thread: CI 2.1.4 + MS SQL 2012 (/showthread.php?tid=66045)



CI 2.1.4 + MS SQL 2012 - Iwanow - 08-28-2016

I got problem with run application wrote in CI 2.1.4 with MS SQL 2012.
So I'm using PHP v 5.6.23, I add sqlsrv driver to ext folder, I'm trying to run app on XAMPP (Apache).
And I got error like:
Code:
A PHP Error was encountered
Severity: Warning
Message: sqlsrv_query() expects parameter 1 to be resource, boolean given
Filename: sqlsrv/sqlsrv_driver.php
Line Number: 152
A PHP Error was encountered
Severity: Warning
Message: sqlsrv_query() expects parameter 1 to be resource, boolean given
Filename: sqlsrv/sqlsrv_driver.php
Line Number: 152

Fatal error: Call to a member function num_rows() on boolean in C:\xampp\htdocs\project-web\src\resources\system\libraries\Session.php on line 216


In logs folder I got:

Code:
ERROR - 2016-08-28 15:40:39 --> Unable to connect to the database
ERROR - 2016-08-28 15:40:39 --> Unable to connect to the database
ERROR - 2016-08-28 15:40:39 --> Severity: Warning  --> sqlsrv_query() expects parameter 1 to be resource, boolean given C:\xampp\htdocs\prompt-web\src\resources\system\database\drivers\sqlsrv\sqlsrv_driver.php 152
ERROR - 2016-08-28 15:40:39 --> Severity: Warning  --> sqlsrv_query() expects parameter 1 to be resource, boolean given C:\xampp\htdocs\prompt-web\src\resources\system\database\drivers\sqlsrv\sqlsrv_driver.php 152
ERROR - 2016-08-28 15:40:39 --> Unable to connect to the database
ERROR - 2016-08-28 15:40:39 --> Severity: Warning  --> sqlsrv_query() expects parameter 1 to be resource, boolean given C:\xampp\htdocs\prompt-web\src\resources\system\database\drivers\sqlsrv\sqlsrv_driver.php 152
ERROR - 2016-08-28 15:40:39 --> Severity: Warning  --> sqlsrv_query() expects parameter 1 to be resource, boolean given C:\xampp\htdocs\prompt-web\src\resources\system\database\drivers\sqlsrv\sqlsrv_driver.php 152



Could any body give me ideas why I get this errors?
I was trying a lot of solutions from stacoverflow, I also tryied this http://forum.codeigniter.com/thread-63060.html
but I got already ODBC driver installed, so please give me your suggestions.