SQLServer

From DreamFactory
Jump to: navigation, search
Line 3: Line 3:
 
==Drivers==
 
==Drivers==
 
===Windows===
 
===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 [http://www.microsoft.com/en-us/download/details.aspx?id=36434  here]. In 32-bit environments, install the x86 package. In 64-bit environments, install the x64 package.
 
*Download and install Microsoft ODBC Driver 11 for SQL Server (if not already installed). Currently this is available [http://www.microsoft.com/en-us/download/details.aspx?id=36434  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 [http://www.microsoft.com/en-us/download/details.aspx?id=29065  here], and the Microsoft SQL Server 2008 R2 Native Client is available [http://www.microsoft.com/en-us/download/details.aspx?id=16978  here].
 
*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 [http://www.microsoft.com/en-us/download/details.aspx?id=29065  here], and the Microsoft SQL Server 2008 R2 Native Client is available [http://www.microsoft.com/en-us/download/details.aspx?id=16978  here].
 
*DreamFactory uses PHP PDO drivers for DB connections. Full documentation on PDO_SQLSRV is available [http://php.net/manual/en/ref.pdo-sqlsrv.php  here]. You will need to download and extract the Microsoft Drivers for PHP for SQL Server. Currently these are available [https://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx  here].
 
*DreamFactory uses PHP PDO drivers for DB connections. Full documentation on PDO_SQLSRV is available [http://php.net/manual/en/ref.pdo-sqlsrv.php  here]. You will need to download and extract the Microsoft Drivers for PHP for SQL Server. Currently these are available [https://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx  here].
*Copy the DLLs for your version of PHP into your PHP's extensions directory. E.g., for PHP 5.5, the DLLs are php_pdo_sqlsrv_55_ts.dll and php_sqlsrv_55_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_55_nts.dll and php_sqlsrv_55_nts.dll).)
+
*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.0.1-1\php\php.ini and save:
+
*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_55_ts.dll''
+
**  ''extension=php_pdo_sqlsrv_56_ts.dll''
**  ''extension=php_sqlsrv_55_ts.dll''
+
**  ''extension=php_sqlsrv_56_ts.dll''
 
*Restart your web server to apply these PHP configuration changes.
 
*Restart your web server to apply these PHP configuration changes.
  

Revision as of 14:39, 22 March 2016

Notes

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

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