note 117302 rejected from function.mssql-connect by cmb
| From: | cmb@php.net | Date: | Tue, 19 May 2015 12:36:01 +0000 |
| Subject: | note 117302 rejected from function.mssql-connect by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-202603@lists.php.net to get a copy of this message | ||
Note Submitter: samuelpremkumar at gmail dot com
----
Please help!!
A newbie to php.
I have manually installed php 5.6.9 on Windows 7, with IIS7.5.
Am trying to connect to SQL Server 2005, i have downloaded drivers and copied the 2 dll files
(php_sqlsrv_56_nts.dll and php_pdo_sqlsrv_56_nts.dll) to the "c:\PHP\ext" folder.
Made relevant changes in the php.ini file under Extensions as below:
extension=php_sqlsrv_56_nts.dll
extension=php_pdo_sqlsrv_56_nts.dll
But when i try to connect, i get this error:
---
Connection could not be established.
Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2]
=> This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL
to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712
[message] => This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the
following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712
) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] =>
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
[message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified ) )
----
Please help.