SQLServer as a System Database

Notes

When connecting to Azure SQL, you'll need to include the hostname in the user credentials

ex: username@hostname, rather than just username

Drivers

Windows

Note: Starting in DreamFactory 2.1.1 drivers and extensions required for PHP 5.6 will need to be used. (changes reflected in this document)

• Download and install Microsoft ODBC Driver 11 for SQL Server (if not already installed). Currently this is available here. In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package.
• Download and install the appropriate SQL Server Native Client (if not already installed and SQL Server is not hosted on the same machine as DSP). In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package. Currently the Microsoft SQL Server 2012 Native Client is available here, and the Microsoft SQL Server 2008 R2 Native Client is available here.
• DreamFactory uses PHP PDO drivers for DB connections. Full documentation on PDO_SQLSRV is available here. You will need to download and extract the Microsoft Drivers for PHP for SQL Server. Currently these are available here.
• Copy the DLLs for your version of PHP into your PHP's extensions directory. E.g., for PHP 5.6, the DLLs are php_pdo_sqlsrv_56_ts.dll and php_sqlsrv_56_ts.dll (which were extracted from the download in the third step). (Rare case: if you are integrating with IIS as your web server, use the non-thread-safe DLLs instead (php_pdo_sqlsrv_56_nts.dll and php_sqlsrv_56_nts.dll).)
• Enable the copied DLLs in your php.ini file. Using the example DLLs from step #4, you would add the following lines to C:\Bitnami\dreamfactory-2.1.1-1\php\php.ini and save:
  • extension=php_pdo_sqlsrv_56_ts.dll
  • extension=php_sqlsrv_56_ts.dll

Note:If you are using DreamFactory 2.1.0-4 or older you will require drivers and extensions for PHP 5.5 (see below)

• Enable the copied DLLs in your php.ini file. Using the example DLLs from step #4, you would add the following lines to C:\Bitnami\dreamfactory-2.1.0-4\php\php.ini and save:
  • extension=php_pdo_sqlsrv_55_ts.dll
  • extension=php_sqlsrv_55_ts.dll

• Restart your web server to apply these PHP configuration changes.

Linux

• In your package manager install the PHP Sybase package.
• Ubuntu/Debian example:

  $ sudo apt-get install php5-sybase

• No other configuration is necessary.