MSSQL Server Connection - Scriptcase - Mac OS X

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 connect to MSSQL Server database

Name - The name chosen for use in connection

Host - IP or server address where the MSSQL Server database

Port - Port configured in MSSQL Server database (default: 1433)

Instance - Instance used in MSSQL Server database

Version - TDS protocol version used (default: 7.0)


Step 3 - Now we must inform the user and password to connect to MSSQL Server database and test the connection.

Server/Host - Configured name in the "Name" of FreeTDS settings

User - User configured on MSSQL Server database (default: sa)

Password - password set in MSSQL Server database

    • Related Articles

    • 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 ...
    • Setting environment manually PHP 5.6 - Mac OS X

      We must follow the steps below to perform the installation of php 5.6 on Mac OS X (Mavericks) Run in terminal: sudo curl -s http://php-osx.liip.ch/install.sh | bash -s 5.6 Installation path: /usr/local/php5 Run in the terminal: sudo nano ...
    • Setting environment manually PHP 5.4 - Mac OS X

      We must follow the steps below to perform the installation of php 5.4 on Mac OS X (Mavericks) Run in terminal: sudo curl -s http://php-osx.liip.ch/install.sh | bash -s 5.4 Installation path: /usr/local/php5 Run in the terminal: sudo nano ...
    • DB2 connection - Scriptcase

      Enabling DB2connection on Scriptcase:   1. Download the instant client of DB2 form the url below or download the file in the final of this tutorial.   - Data Server Driver Package 10.5 - http://www-01.ibm.com/support/docview.wss?uid=swg27016878 ...
    • 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 ...