Iniciar uma conversa

Connection with MSSQL Database

Scriptcase has 5 types of connections that can be used to communicate with Database MSSQL Server.

- MSSQL Server Native SRV PDO

- MSSQL Server Native SRV

- MSSQL Server ODBC

- MSSQL Server (PHP Module)

 

1. Connection ODBC (MSSQL Server ODBC)

 

This connection may be used on the following Operating Systems.

 

Linux (FreeTDS)

Windows 8

Windows 7

Windows Server 2012

- Windows Server 2008

- Windows Server 2003

- Windows XP

 

In case you are using linux, a connection is possible with an extension module FreeTDS.

The driver that allows the success to ODBC through PHP is compiled in 32 bit. If you are using Windows 64 bits, it’s necessary to create a ODBC connection using the program “odbcad32.exe” that can be found in the directory “/Windows/SysWOW64/”.

Example:

C:\Windows\SysWOW64\odbcad32.exe

 

For more details about this connection, click here.

 

2. Connection of MSSQL – PHP Module (MSSQL Server)

 

This connection can be used on all Operating Systems.

The installer .exe of Scriptcase, that can be download from our site, already has the dll necessary to use the module. Leaving you only to uncomment the line:

extension=php_mssql.dll

 

For more details about this connection, click here.

 

3. Connection Native SRV (MSSQL Server Native SRV)

This connection can be used on the following Operating Systems:

 

- Windows 8

- Windows 7

- Windows XP Service Pack 2

Windows Server 2012

- Windows Server 2008

Windows Server 2003 Service Pack 1

 

A Native SRV connection is the most recommend for use on Scriptcase. This type of connection has better performance, also the only one that works perfectly with the field type’s image and document (database).

The installation of these modules is manually and has 2 steps.

 

Install the Microsoft SQL Server Native Client – sqlncli

Install the Driver – SQLServerDriverForPHP

Escolher arquivos ou arraste e solte arquivos
Esse artigo foi útil?
Sim
Não
  1. Álvaro Moura

  2. Publicado
  3. Atualizado

Comentários