Native SRV Driver Installation in Windows Environment

Below are step-by-step instructions for installing the Native SRV driver:

 

Required:

• Operating System

* Windows Server 2003 Service Pack 1

* Windows XP Service Pack 2

* Windows Vista

* Windows Server 2008

* Windows Seven

• Microsoft SQL Server Native Client Installed- sqlncli

http://go.microsoft.com/fwlink/?LinkId=101877

• SQLServerDriverForPHP Driver installed
  

http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx

 

 

 

 

 

If you wish use the ADO, ODBC or PHP module connection, it is recommended to use the webhelp tutorial:

http://downloads.scriptcase.com.br/downloads/v7/manual/en_us/webhelp/manual_mp/06-Tutoriais/11-mssql/04-srv.htm

 

First Step: Microsoft SQL Server Native Client Installation- sqlncli

 

After download the file "sqlncli.msi", execute and follow the installer steps.

 

*After installation, it is recomended reboot the operating system.

 

 

 

Second Step: SQLServerDriverForPHP Driver installation

 

After executing the "SQLServerDriverForPHP", assign the "ext" folder path in php, according to instructions.

The installer will extract "dlls" that will be used from php to raise the service.

 

 

After Installation, it is necessary to enable in php.ini the following dll:

• php_sqlsrv_ts.dll

 If it is installed the sqlncli 2005 with the SQLServerForPHP 1.0

* Version recommended to MSSQL less or equal to 2005.

Examplo of Code:

extension=php_sqlsrv_ts.dll

 

• php_sqlsrv_52_ts_vc6.dll

 If it is installed the sqlncli 2008 with the SQLServerForPHP 1.1 or SQLServerForPHP 2.0

* Version recommended to MSSQL equal or top to 2005.

Examplo of Code:

extension=php_sqlsrv_52_ts_vc6.dll

* It is necessary include the line after calling the extension php_mssql.dll

 

 

After editing the file "php.ini", it is necessary to reboot the "apache" service in : "Control Painel-> Administrative Tools-> Service-> ApacheScriptcase5".

 

Final Step: Create the connection mssql SRV in scriptcase v5.

To create the connection, choose the option: MSSQL Server NATIVE SRV