Differences

This shows you the differences between two versions of the page.

--- database:microsoft_sql_server [2015/11/28 00:11] – mnewnham
+++ v5:database:microsoft_sql_server [2018/07/08 01:08] – [mssqlnative] mnewnham
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 ===== Description =====
-There are 2 supported drivers that allow connections to Microsoft SQL Server databases. The first, **mssqlnative** allows connections from Windows Clients to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. The second, **mssql** allows connections from Unix based clients using the freetds libraries.
+There are 2 supported drivers that allow connections to Microsoft SQL Server databases.
+==== mssqlnative ====
+This driver, which runs on both Windows and Linux clients, allows connections to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. This driver is recommended for Windows Clients running PHP 5.3 and higher, and Linux Clients running PHP 7.0 and higher, and provides the fastest PHP connection.
+More about the Microsoft SQL Server client for Linux [[https://github.com/Microsoft/msphpsql|here]]
+==== mssql====
+This allows connections from Unix based clients using the freetds libraries. It can be used with version 5.x of PHP
+More about the FreeTDS libraries [[http://www.freetds.org/|here]]
 ==== SQL Server 2003 ====
 Connecting to SQL server 2003 creates a difficulty There is no support for native client connections, and the alternative method, using php_mssql.dll was removed in PHP 5.3. The only alternative is to use a generic ODBC driver that does not require the Microsoft Native Client libraries.
@@ Line 13: / Line 22: @@
 ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes|
-^Unix|No|
+^Unix|Yes|
 ^ADOdb V5|Yes|
 ^ADOdb V6|Yes|
 == Alternatives ==
-[[database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]
+[[v5:database:pdo#pdo_sqlsrv|PDO driver for SQL Server]]\\
+[[v5:database:odbc#odbc_mssql|ODBC driver for SQL Server]]\\
 </WRAP>
-**This is the preferred driver for connecting to a SQL server database from Windows clients.**
+**This is the preferred driver for connecting to a SQL server database from both Windows and Linux clients.**
-This driver was contributed by Microsoft and provides connections to SQL server databases greater than version 2000. It requires PHP version 5.3 or greater, Microsoft native client software and the appropriate PHP driver.
+The original driver was contributed by Microsoft and provides connections to SQL server databases greater than SQL Server 2003.
+  * On Windows clients, It requires PHP version 5.3 or greater, Microsoft native client software and the appropriate PHP driver.
+  * On Linux clients, PHP version 7.0 and higher is required.
 Sequences are supported in native mode in SQL Sever 2012, and emulated in earlier versions.
+--------------------------------
+==== DateTime Fields ====
+The default behavior for the **PHP** mssqlnative driver is to return date/time fields as a PHP [[http://php.net/manual/en/class.datetime.php|dateTime]] object, that looks like this:
-{{tag>[SQL_Server windows active]}}
+  [RequiredDate] => DateTime Object
+  (
+      [date] => 1996-08-01 00:00:00.000000
+      [timezone_type] => 3
+      [timezone] => America/Denver
+  )
+However, in order to improve portability, the default behaviour of the **ADOdb** mssqlnative driver is to return the date as a string:
+  [RequiredDate] => 1996-08-01 00:00:00.000000
+In order to return the dateTime as an object, the following action is required:
+<code php>
+$db = ADONewConnection('mssqlnative');
+$db->setConnectionParameter('ReturnDatesAsStrings',false);
+$db->connect('SERVER\SQLEXPRESS','user','password','NORTHWND');
+</code>
+===== Unicode Strings =====
+You can set the character set to UTF-8 using:
+<code php>
+$db = ADONewConnection('mssqlnative');
+$db->setConnectionParameter('characterSet','UTF-8');
+$db->connect('SERVER\SQLEXPRESS','user','password','NORTHWND');
+</code>
+===== Using Windows Authentication =====
+To use Windows, instead of SQL Server authentication, pass NULL as the user and password as shown below
+<code php>
+$db = ADONewConnection('mssqlnative');
+$db->connect('SERVER\SQLEXPRESS',NULL,NULL,'NORTHWND');
+</code>
 ------------------------------
-====== mssql (Unix) ======
+===== mssql (Unix) =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 41: / Line 87: @@
 ^ADOdb V6|Yes|
 == Alternatives ==
-[[database:pdo#pdo_mssql|PDO driver for FreeTDS]]
+[[v5:database:pdo#pdo_mssql|PDO driver for FreeTDS]]
 </WRAP>
 **This is the preferred driver for connecting to a SQL server database from Linux/Unix clients.**
@@ Line 48: / Line 94: @@
 {{tag>[SQL_Server unix active freetds]}}
 --------------------------------------
-====== mssql (Windows) ======
+===== mssql (Windows) =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 62: / Line 108: @@
 This driver was the primary connection method to SQL Server databases up to PHP Version 5.2. The windows dll associated with this driver (php_mssql.dll) was removed from the standard PHP distribution in PHP Version 5.3. There is no community support for this driver.
-{{tag>[SQL_Server windows deprecated]}}
 ----------------------------------------------------
-====== mssqlpo ======
+===== mssqlpo =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 79: / Line 125: @@
 {{tag>[SQL_Server unix windows active portable]}}
-====== mssql_n ======
+===== mssql_n =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 92: / Line 138: @@
 This driver appears to provide Unicode enhancements to the mssql driver
-{{tag>[SQL_Server unix unicode supported]}}
+{{tag>["Microsoft SQL Server" unicode freetds windows]}}