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

    • 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 ...
    • 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 ...
    • Manual Update - Mac OS

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Settings> Administration, in the side menu go to Services> Backup. A file (.ZIP) will be generated with all your projects, save this file ...
    • 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 ...
    • 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. ...