note 117302 added to function.mssql-connect

From: 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

« previous php.notes (#202602) next »