I am unable to configure the sqlsrv drivers in php7

Question

In the archive php.ini all extensions are found, except the ones I need to connect to SQL Server database.

extension=php_sqlsrv_7_ts_x64.dll
extension=php_pdo_sqlsrv_7_ts_x64.dll

As .dll are in the folder C:\php7\ext.

In the php.ini is mapped:

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
extension_dir = "C:\php7\ext"

When I execute php.exe, it returns the following message:

the procedure entry point call_user_function could not be locale in the dynamic library C:\php7\ext\php_pdo_sqlsrv_7_ts_x64.dll
the procedure entry point call_user_function could not be locale in the dynamic library C:\php7\ext\php_sqlsrv_7_ts_x64.dll

Answer 1

Download the package Microsoft Drivers for PHP for SQL Server and unzip into a folder and take these two files to the folder ext of php:

To x86:

extension=php_sqlsrv_7_nts_x86.dll
extension=php_pdo_sqlsrv_7_nts_x86.dll

To x64:

extension=php_sqlsrv_7_nts_x64.dll
extension=php_pdo_sqlsrv_7_nts_x64.dll

---

Test the connection with:

$localhost = "localhost";
$database  = "testdb";
$user = "sa";
$pass = "12345";
$c = new PDO("sqlsrv:Server=$localhot;Database=$database", $user,$pass);

adjusting the settings of your seat.

_References:

• Microsoft Drivers for PHP for SQL Server
• PDO_SQLSRV DSN
• Documentation - Microsoft Drivers for PHP for SQL Server

Answer 2

I also had problem and I could not this way, I used the same PDO and it worked

  $p= new PDO('odbc:Driver={SQL Server};Server=NOMEDOSERVER;Database=NOMEDOBANCO; Uid=LOGIN;Pwd=SENHA');

  $stmt = $p->prepare("SELECT *  FROM usuario");