note 117302 added to function.mssql-connect
| From: | samuelpremkumar at gmail dot com | Date: | Tue, 19 May 2015 12:26:35 +0000 |
| Subject: | note 117302 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202602@lists.php.net to get a copy of this message | ||
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.
----
Server IP: 72.52.91.14
Probable Submitter: 121.217.239.180
----
Manual Page -- http://php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/117302
Del: integrated -- https://master.php.net/note/delete/117302/integrated
Del: useless -- https://master.php.net/note/delete/117302/useless
Del: bad code -- https://master.php.net/note/delete/117302/bad+code
Del: spam -- https://master.php.net/note/delete/117302/spam
Del: non-english -- https://master.php.net/note/delete/117302/non-english
Del: in docs -- https://master.php.net/note/delete/117302/in+docs
Del: other reasons-- https://master.php.net/note/delete/117302
Reject -- https://master.php.net/note/reject/117302
Search -- https://master.php.net/manage/user-notes.php