1

Topic: How to be connected to MSSQL to the server from PHP7.2?

All categorical greetings.
The question - is had CentOS7 with installed Apache+php7.2
I can not force to work with MSSQL (exterior).
There are any adequate instructions or it is better - personal experience of setting.
That made - downloaded with microsoft a site a dial-up of "drivers" for operation, added in extensions + registered in php.ini
It was convinced that ports are opened on MSSQL and WEB servers.
For today - all took down, reinstalled a WEB-environment, I search the help.
The moderator: the Subject is transferred from a forum "Microsoft SQL Server".

2

Re: How to be connected to MSSQL to the server from PHP7.2?

MSSQL 2012

3

Re: How to be connected to MSSQL to the server from PHP7.2?

FlipWho;
There is usage experience on WIN/IIS/PHP, can and fits in your case
SQLSRV40.exe on a site  (at you already is as I understood).
In PHP.ini register corresponding to yours to assembly PHP dll:
VC15 x64 Non Thread Safe (2018-May-24 8:14:11 PM)
extension=php {_pdo} _sqlsrv_7_nts_x64.dll
VC15 x64 Thread Safe (2018-May-24 8:14:22 PM)
extension=php {_pdo} _sqlsrv_7_ts_x64.dll
VC15 x86 Non Thread Safe (2018-May-24 8:14:14 PM)
extension=php {_pdo} _sqlsrv_7_nts_x86.dll
VC15 x86 Thread Safe (2018-May-24 8:14:30 PM)
extension=php {_pdo} _sqlsrv_7_ts_x86.dll
Be convinced that are installed SQL Server Native Client Drivers corresponding to your version SQL. (It is not assured that for CentOS it is required).
Microsoft practically does not support these the driver - updates quit extremely rarely and crookedly.
There is a chance that the current version stupidly does not support 7.2 (but 7.1 on mine windows to the machine works).

4

Re: How to be connected to MSSQL to the server from PHP7.2?

wrote:

That made - downloaded with microsoft a site a dial-up of "drivers" for operation, added in extensions + registered in php.ini

After that in phpinfo the driver was visible?

5

Re: How to be connected to MSSQL to the server from PHP7.2?

Hett, here it where true of my omission!
Did not look, from a word absolutely.
Also it seems, I missed one moment. PDO_ODBC I did not put, and, probably, it is necessary for operation PDO_SQLSRV

6

Re: How to be connected to MSSQL to the server from PHP7.2?

Asked a question at forum ISPmanager (therefore as a server with this panel).
[url =] http://forum.ispsystem.ru/showthread.ph … 2-5--MSSQL [/url]
The answer will be checked up and laid out here.