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

ADS MSSQL Server
MSSQL Server Native SRV RFQ
MSSQL Server Native SRV
MSSQL Server ODBC
MSSQL Server (PHP Module)

 

 

1. ADO connection (MSSQL Server ADO):

 This connection can be used on the following operating systems:

- Windows Server 2003/2008/2012

- Windows 7

- Windows 8 / 8.1

 

The scriptcase .exe installer, which you can download from the website, already has the necessary configuration for using this module.

For more details on this type of connection, click here.

 

2. ODBC connection (MSSQL Server ODBC):

This connection can be used on the following operating systems:

* Linux (FreeTDS)

* Windows 7

* Windows Server 2008

* Windows Vista

* Windows Server 2003
* Windows XP

* Windows Server 2000

* Windows 98

 

If using a linux environment, the connection will be possible with the aid of the FreeTDS module.

 

The drive that allows access to odbc through PHP is compiled in 32 bits. If you are using a 64-bit Windows environment, you will need to create odbc using the "odbcad32.exe" program, which should be located inside the "../windows/syswow64/" folder.

Example:

C: \ Windows \ SysWOW64 \ odbcad32.exe

For more details on this type of connection, click here.

 

3. MSSQL connection - PHP module (MSSQL Server):

 

This connection can be used in all versions of the operating system.

 

The scriptcase .exe installer, which can be downloaded from the site, already has the necessary dll for using this module. Just for your use, uncomment the line:

extension = php_mssql.dll

Note: The line is in the php.ini file

For more details on this type of connection, click here:

 

4. Native SRV connection (MSSQL Server NATIVE SRV):

 

This connection can be used on the following operating systems:

* Windows Server 2003 Service Pack 1

* Windows XP Service Pack 2

* Windows Vista

* Windows Server 2008

* Windows 7

 

The Native SRV connection is the most recommended for use in the scriptcase. It has a higher speed of access to the database, in addition to being the only one that works perfectly with the image and document database fields.

 

The installation of this module is manual and has two steps:

Have Microsoft SQL Server Native Client installed - sqlncli
Owning the Driver - SQLServerDriverForPHP
 

For more details on this type of connection, click here.
```

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=98y1h1a6944e9f2044766ba7f2944a7fa6aef)