Connection with MSSQL Database

Connection with MSSQL Database

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

- MSSQL Server Native SRV PDO

- MSSQL Server Native SRV

- MSSQL Server ODBC




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 Native SRV and Native SRV PDO (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


    • Related Articles

    • Change Database Context – MSSQL

      If you use the connection “MSSQL Server” and it shows you an error called “Changed database context to 'database name' ” it's because of the MSSQL Server driver which is available from PHP, because it isn't updated frequently. So, when in this driver ...

    • MSSQL Server Connection - Scriptcase - Mac OS X

      Currently we must set up the connection to SQL Server on computers running Mac OS X according to the steps below: Step 1 - We should access the connection setup, in this case MSSQL Server Click on "Set FreeTDS". Step 2 - We must set the data to ...

    • Filtering Connection Database - Oracle

      On various occasions, we encounter slowness when connecting to the database or while editing and executing applications. It is possible to resolve these issues by optimizing data loading through filter configuration. To do so, follow these steps: ...

    • Using the Database Builder

      The DataBase Builder is a Scriptcase 'DBMS' (Database Manager System), this tool allows you to create tables, modify the structure of your tables, generate ER diagrams (Entity x Relationships), perform the export of the tables among other things. ...

    • Filter Oracle Connection

      If the error above appears when connecting to the database and then creating a new application, it is necessary to make some changes regarding the database: Obs: For such changes it is necessary to know the owner who has view of the tables, such ...