LIX. Microsoft SQL Server Functions
Introduction
These functions allow you to access MS SQL Server database.
Requirements
Requirements for Win32 platforms.
The extension requires the MS SQL Client Tools to be installed
on the system where PHP is installed. The Client Tools can
be installed from the MS SQL Server CD or by copying ntwdblib.dll
from \winnt\system32 on the server to \winnt\system32 on
the PHP box. Copying ntwdblib.dll will only provide access.
Configuration of the client will require installation of
all the tools.
Requirements for Unix/Linux platforms.
To use the MSSQL extension on Unix/Linux, you first need
to build and install the FreeTDS library. Source code and
installation instructions are available at the FreeTDS home
page: http://www.freetds.org/
Note: In Windows, the DBLIB from Microsoft is used. Functions
that return a column name are based on the dbcolname() function
in DBLIB. DBLIB was developed for SQL Server 6.x where the
max identifier length is 30. For this reason, the maximum
column length is 30 characters. On platforms where FreeTDS
is used (Linux), this is not a problem.
Installation
The MSSQL extension is enabled by adding extension=php_mssql.dll
to php.ini.
To get these functions to work, you have to compile PHP
with --with-mssql[=DIR], where DIR is the FreeTDS install
prefix. And FreeTDS should be compiled using --enable-msdblib.
|