You are here

Home » API reference » Drupal driver for SQL Server and SQL Azure 7.2

README.txt in Drupal driver for SQL Server and SQL Azure 7.2

Same filename and directory in other branches
  1. 8 README.txt
  2. 7.3 README.txt
  3. 7 README.txt
# SQL Server driver for Drupal 7

See http://drupal.org/project/sqlsrv for installation instructions.

System Requirements

ODBC 11 (https://www.microsoft.com/en-us/download/details.aspx?id=36434)
Wincache >= 1.3.7.4 (http://sourceforge.net/projects/wincache/)
PDO >= 3.2.0.0 (http://www.microsoft.com/en-us/download/details.aspx?id=20098)
PHP >= 5.4
MS SQL Server >= 2012

# WincacheDrupal Dependency

The driver needs the Wincache PHP extension.

To properly leverage performance gains of the driver, you need to run it
in combination with the WincacheDrupal module:

https://www.drupal.org/project/wincachedrupal

Proper setup of the WincacheDrupal module is not trivial, and requires to manually
modify the settings.php file.

Se the README.txt in the WincacheDrupal module. The *important* lines are:

// Register the new cache backend
$conf['cache_backends'][] = 'sites/all/modules/wincachedrupal/drupal_win_cache.inc';
// This is the cache binary of the SQL Server driver
$conf['cache_class_fastcache'] = 'DrupalWinCache';
// We rely on memory locks to make this work
$conf['lock_inc'] = 'sites/all/modules/wincachedrupal/wincache-lock.inc';

If this is not properly setup, the SQL Server Driver will detect the situation
and disable the custom caching backend.

File

README.txt
View source 
  1. 

  2. # SQL Server driver for Drupal 7

  3. 

  4. See http://drupal.org/project/sqlsrv for installation instructions.

  5. 

  6. System Requirements

  7. 

  8. ODBC 11 (https://www.microsoft.com/en-us/download/details.aspx?id=36434)

  9. Wincache >= 1.3.7.4 (http://sourceforge.net/projects/wincache/)

  10. PDO >= 3.2.0.0 (http://www.microsoft.com/en-us/download/details.aspx?id=20098)

  11. PHP >= 5.4

  12. MS SQL Server >= 2012

  13. 

  14. # WincacheDrupal Dependency

  15. 

  16. The driver needs the Wincache PHP extension.

  17. 

  18. To properly leverage performance gains of the driver, you need to run it

  19. in combination with the WincacheDrupal module:

  20. 

  21. https://www.drupal.org/project/wincachedrupal

  22. 

  23. Proper setup of the WincacheDrupal module is not trivial, and requires to manually

  24. modify the settings.php file.

  25. 

  26. Se the README.txt in the WincacheDrupal module. The *important* lines are:

  27. 

  28. // Register the new cache backend

  29. $conf['cache_backends'][] = 'sites/all/modules/wincachedrupal/drupal_win_cache.inc';

  30. // This is the cache binary of the SQL Server driver

  31. $conf['cache_class_fastcache'] = 'DrupalWinCache';

  32. // We rely on memory locks to make this work

  33. $conf['lock_inc'] = 'sites/all/modules/wincachedrupal/wincache-lock.inc';

  34. 

  35. If this is not properly setup, the SQL Server Driver will detect the situation

  36. and disable the custom caching backend. 

  37.