SQLServer

From DreamFactory
Jump to: navigation, search
 
Line 3: Line 3:
 
*Download and install the appropriate SQL Server Native Client (if not already installed and SQL Server is not hosted on the same machine as DreamFactory). 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 DreamFactory). 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://github.com/Microsoft/msphpsql/releases/tag/4.1.0  here]. Be sure to download BOTH x86 zip files (sqlsrv AND pdo_sqlsrv.) You need the x86 version because the Bitnami PHP is 32 bit.  
 
*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://github.com/Microsoft/msphpsql/releases/tag/4.1.0  here]. Be sure to download BOTH x86 zip files (sqlsrv AND pdo_sqlsrv.) You need the x86 version because the Bitnami PHP is 32 bit.  
*Copy the DLLs for your version of PHP into your PHP's extensions directory.  
+
*Copy the DLLs for your version of PHP into your PHP's extensions directory. Make sure you grab the thread safe (ts) versions.
 
*Enable the copied DLLs in your php.ini file. The php.ini file is C:\Bitnami\dreamfactory-2.7.0-1\php\php.ini. Be sure to change these example file names to match the name of the files you extracted in the previous step.
 
*Enable the copied DLLs in your php.ini file. The php.ini file is C:\Bitnami\dreamfactory-2.7.0-1\php\php.ini. Be sure to change these example file names to match the name of the files you extracted in the previous step.
 
**  ''extension=php_pdo_sqlsrv_7_ts.dll''
 
**  ''extension=php_pdo_sqlsrv_7_ts.dll''
 
**  ''extension=php_sqlsrv_7_ts.dll''
 
**  ''extension=php_sqlsrv_7_ts.dll''
 
*Restart your Bitnami stack to apply these PHP configuration changes.
 
*Restart your Bitnami stack to apply these PHP configuration changes.

Latest revision as of 12:58, 3 August 2017

Note: Starting in DreamFactory 2.3, drivers and extensions required for PHP 7 will need to be used, as reflected in these instructions.

  • Download and install Microsoft ODBC Driver 11 for SQL Server (if not already installed). Currently this is available 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 DreamFactory). 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. Be sure to download BOTH x86 zip files (sqlsrv AND pdo_sqlsrv.) You need the x86 version because the Bitnami PHP is 32 bit.
  • Copy the DLLs for your version of PHP into your PHP's extensions directory. Make sure you grab the thread safe (ts) versions.
  • Enable the copied DLLs in your php.ini file. The php.ini file is C:\Bitnami\dreamfactory-2.7.0-1\php\php.ini. Be sure to change these example file names to match the name of the files you extracted in the previous step.
    • extension=php_pdo_sqlsrv_7_ts.dll
    • extension=php_sqlsrv_7_ts.dll
  • Restart your Bitnami stack to apply these PHP configuration changes.