Введение

These functions allow you to access MS SQL Server database.

Коментарии

SQLSRV is not exactly a "driver": it's a completely different PHP extension to access SQL Server databases and it has its own syntax and features. It's a Windows-only library developed and maintained by Microsoft and it's not related to the built-in SQL Server extension described here.

(Whatever, it's quite feature-rich and it's easy to learn.)
2009-12-16 10:40:32
http://php5.kiev.ua/manual/ru/intro.mssql.html
to use MSSQL-connections on Linux with PHP7 you can use PDO with PDO_DBLIB.

Install driver using this command: 
sudo apt-get install php7.0-sybase

then simply connect with this:

<?php
    $dsn 
"dblib:host=" $host ":1433;dbname=" $database;
   
$dblink = new PDO ($dsn$user$pass);
?>

I got problems when i used the hostname, so i switched to the IP of the server.

Later I got problems to insert records into MSSQL-table.
This settings helped me out:

<?php
    $dblink
->exec("SET ANSI_WARNINGS ON");
   
$dblink->exec("SET ANSI_PADDING ON");
   
$dblink->exec("SET ANSI_NULLS ON");
   
$dblink->exec("SET QUOTED_IDENTIFIER ON");
   
$dblink->exec("SET CONCAT_NULL_YIELDS_NULL ON");
?>
2016-04-19 12:31:51
http://php5.kiev.ua/manual/ru/intro.mssql.html
The microsoft SQLSRV driver for linux is functional.

According Microsoft, version 4.0 (for Linux):
    Ubuntu 15.04 (64-bit)
    Ubuntu 16.04 (64-bit)
    Red Hat Enterprise Linux 7 (64-bit)

(https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver)

Instalations notes for Linux:
(https://github.com/Microsoft/msphpsql)
2017-03-14 17:02:27
http://php5.kiev.ua/manual/ru/intro.mssql.html

    Поддержать сайт на родительском проекте КГБ