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");
?>
Einführung
Warnung
Dieses Feature wurde in PHP 7.0.0 REMOVED (entfernt).
Alternativ können folgende Features verwendet werden:
Diese Funktionen ermöglichen Ihnen den Zugriff auf den MS SQL-Datenbankserver.
Diese Erweiterung steht unter Windows ab PHP 5.3 nicht mehr zur Verfügung.
Microsoft stellt mit SQLSRV eine alternative Erweiterung für die Konnektivität von MS SQL zur Verfügung: » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx.
add a note
User Contributed Notes 3 notes
rjaehnrich at gmail dot com ¶
8 years ago
yanko dot costa at gmail dot com ¶
7 years ago
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)
alvaro at demogracia dot com ¶
14 years ago
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.)
