• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CI 2.1.4 + MS SQL 2012

#1
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.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2017 MyBB Group.