Connecting with MS SQL Server Native SRV PDO

To enable MS SQL Server Native SRV extension you must install Microsoft ODBC Driver 11 for SQL Server.

The following operating systems are recommended:

Operating Systems

Windows Server 2012

Windows 8

Windows Server 2008 R2

Windows 7 SP1

Windows Vista SP2

Microsoft ODBC Driver 11 for SQL Server - Download

ODBC Driver 11 64 bits

ODBC Driver 11 32 bits

Open topic with navigation

Drivers MSSQL Server

Currently Scriptcase offers four drivers to with MSSQL Server database: MSSQL Server Native SRV, MSSQL Server Native SRV PDO, MSSQL Server ODBC and MSSQL Server.

Currently Scriptcase offers two drivers to connect with MSSQL Server database: MSSQL Server ODBC e MSSQL Server.

You can see the features below:

MSSQL Server Native SRV PDO ( Recommended ) : Allows the connection to be made, using the native driver for MSSQL Server for Windows.

MSSQL Server Native SRV : Allows the connection to be made, using the native driver for MSSQL Server for Windows.

MSSQL Server : Allows the connection to be made, using the native PHP driver for MSSQL Server.

MSSQL Server ODBC : Allows the connection to be made using a MSSQL Server ODBC Data Source.

MSSQL Server ( Recommended ): Allows the connection to be made, using the native PHP driver for MSSQL Server.

MSSQL Server ODBC : Allows the connection to be made using a MSSQL Server ODBC Data Source.

MSSQL Server ( Recommended ): Allows the connection to be made, using the native PHP driver for MSSQL Server.

MSSQL Server ODBC : Allows the connection to be made using a MSSQL Server ODBC Data Source.

Below you will find the step-by-step to install Microsoft ODBC Driver 11 for SQL Server and connect to Scriptcase.

Installing Microsoft ODBC Driver 11 for SQL Server

After downloading the file, run the installer and follow the steps below:

Accept the license agreement and click 'Next'.

In this part, select the option "Client Components".

Note: Select the option "ODBC Driver for SQL Server SDK", once the components that we will need are also in this option.

Click 'Install' to begin the client installation.

The program features you selected are being installed.

Click 'Finish' to exit.

Connecting to Scriptcase

Connecting to MSSQL Server on Scriptcase

Open topic with navigation

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with MSSQL Server Native SRV PDO.

Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on the toolbar go to the marked icon in the image below, referring to “New Connection”.

Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the MSSQL Server image.

Step 3: On the following image, place the required information:

Connection Name - Define the name of your new connection.
DBMS Driver - Allows you to define the driver that’ll be used, by default it’s Native SRV PDO, Native SRV , MSSQL Server ou ODBC.
Test Connection - Validates the connection and informs if it was successful or not.
Server/Host (Name or IP) -Inform the server IP or name where the database is installed.
Database Name - Enter the MySQL database instance name.
Username - Enter a valid database user name. If you are connecting with a remote database server, check if the database user has remote access.
Password - Enter the valid password.

For more details on configuring the connection of the database click on Advanced

Decimal Separator - Select the type of separator, between coma and period.
Persistent Connection - Persistent connections are connections that don’t close after running your script.
Use the schema before the table name - Allows the use of schemas before the table names.

Filter - Clicking on this tab, the following page will appear:

Show - Allows to show Tables, Views, System Tables and Procedures.
Searches - Allows to define which tables and owners will be shown.

Step 4: Always test your connection before saving, if the message “Connection Success” appears, then save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password, Database and Server/Host.

Verify if the module is enabled in the diagnosis.