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 ...
    • 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 Connection

      Some databases use schemes to organize internally their data, just like Oracle, PostgreSQL, and SQL Server. Such feature is great when known and used correctly. The problem is when the database has a lot of schemes, that results in delay at the time ...
    • Oracle Connection - Scriptcase

      On several occasions we face slowly at the time of connection to the database or the editing and running applications.   To resolve this issue we can set the connection filter for the loading of data is optimized. To do this, follow these steps: ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Using friendly URL

      The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...
    • Correcting access error for the Scriptcase database

      Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below:   This problem happens when we change the folder name of the scriptcase to another name, such as "sc". Then, the error happens because the complete ...
    • Necessary libraries to install the Scriptcase in Windows 7

      To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...