I found lots of answers about this question and it is asked in stackoverflow as well, but that answers do not solve my problem.
The method they are telling in the forums and Q/A websites to connect PHP with MS SQL Server, I am using the same but I am getting the following error in YII Framework
CDbConnection failed to open the DB connection: SQLSTATE[IMSSP]: This extension requires the Microsoft SQL Server 2012 Native Client ODBC Driver to communicate with SQL Server. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712
- I have installed the Microsoft SQL Server 2012 Native Client ODBC driver from the given link above.
- I have included the following lines in php.ini
extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll
- I have save the above dlls in php/ext folder.
But still I am getting this error. Moreover I have also made a System DSN in ODBC Data Source Administrator in Administrative Tools in Windows.
But I didn't found the solution of my problem.
Please help me out to solve this problem.
Thanks!