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