Open topic with navigation

Connecting with MS SQL Server

 

The scriptcase installer come by default with the extension MS SQL Server enabled.

The connection is available on any MacOS.

 

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.

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.

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.

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:

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

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

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.