Feedback

Enabling Azure MSSQL Server ODBC

At Scriptcase, we have the following drivers available for connection to Azure MSSQL Server: MSSQL Server NATIVE SRV, MSSQL Server NATIVE SRV PDO and MSSQL Server ODBC . If you are using your own pre-configured environment, the MSSQL Server extensions must be enabled manually in PHP.

Prerequisites

Before proceeding with this documentation, check your PHP architecture. For drivers to be enabled correctly, files must be downloaded according to the architecture used.

  • In your Scriptcase, there is the file info.php, access it by the URL: http://127.0.0.1:8092/scriptcase/info.php, where you will find the information regarding the architecture in phpinfo().

NOTE: If you are using Scriptcase’s automatic installer, the PHP architecture will be the same as the one you downloaded. Download Microsoft ODBC Driver 11 For SQL Server according to your PHP architecture .

PHP Architecture

  • Architecture x86 = 32 bits
  • Architecture x64 = 64 bits

Listed below are the necessary files for the drivers to be enabled.

Required files:

x64

  • Microsoft ODBC Driver 11 For SQL Server (x64): Click Here

x86

  • Microsoft ODBC Driver 11 For SQL Server (x86): Click Here

Other Files

  • PHP extensions (php_pdo_sqlsrv_73_nts_x64 and php_sqlsrv_73_nts_x64): Click Here

Compatibility Table

  Server 2016 Server 2012 /R2 Windows 10 Windows 8 / 8.1 Server 2008 SP2 / R2 SP1 Windows 7 SP1 Windows Vista SP2
Native SRV PDO Disponível Disponível Disponível Disponível Disponível Disponível  
Native SRV Disponível Disponível Disponível Disponível Disponível Disponível  
ODBC Disponível Disponível Disponível Disponível Disponível Disponível Disponível

IMPORTANT: if you need to use Database Identifiers in your tables, we recommend using the double quotation marks( ) instead of the brackets( [ ] ) because of the conflict with the of Global Variables syntax Scriptcase. Using the brackets as database identifiers may lead to problems in the Scriptcase applications.

Configuring and enabling Azure MSSQL Server ODBC on Windows

IMPORTANT: If you are using Scriptcase’s automatic installer, the extensions are already enabled in PHP, requiring only the installation of the client. Proceed to item 3.

1 - Extract the .zip file and copy the files from the php_pdo_sqlsrv_73_nts_x64 and php_sqlsrv_73_nts_x64 .dll extensions previously downloaded to your PHP’s ext folder.

2 - In the php.ini file, located in C:\php, add the lines referring to the MSSQL Server extensions php_pdo_sqlsrv_73_nts_x64 and php_sqlsrv_73_nts_x64. See the example below:

extension=php_pdo_sqlsrv_73_nts_x64
extension=php_sqlsrv_73_nts_x64

Enabling MSSQL extensions

3 - After downloading the Microsoft ODBC Driver 11 For SQL Server file, run the installer and follow the steps below:

Installation Wizard.

4 - Accept the terms of the license agreement and click next.

Installation Wizard.

5 - Check the option “ODBC Driver for SQL Server SDK”, because the components that we will need are also in this option.

Installation Wizard.

  • In this option, leave the option “Client Components” checked.

6 - Click Install to start the client installation.

Installation Wizard.

7 - The program features you selected are being installed.

Installation Wizard.

8 - Click finish to exit.

Installation Wizard.

9 - Restart the Apache service using the Task Manager.

  • Open the Task Manager and click on the Services tab.

  • Look for the ApacheScriptcase9php73 or Apache2.4 service and right click on this service, then Restart.

Restarting Apache

Connection to Scriptcase

Questions or Connection Problems?

Contact our support in case of connection problems or questions regarding this database.