Open Windows Explorer.
Browse to: [fw folder]\Setup\Database - MSSQL\Microsoft SQL Server Driver for PHP\
Double-click the setup file. The Microsoft SQL Server Driver for PHP installation will begin.
Click the Yes The File Extraction step will be displayed.
Enter a location to extract the files (e.g., C:\phpext\). If the folder does not exist, confirm the folder creation. The files will be extracted.
Browse to the extracted file location (e.g., C:\phpext\).
Copy the following files:
- php_sqlsrv.dll
- php_sqlsrv_ts.dll
Browse to: C:\php\ext\
Paste the files into the C:\php\ext\ folder.

After pasting the files, the location of the extracted files can be safely deleted

...

Step 4 - PHP Configuration

...

The following default settings may be different to those listed depending on the PHP version (the following is based on PHP 5.3.xx).

Field Name	Default Setting	Required Setting
safe_mode	Off	Off
max_execution_time	30	60
error_reporting **	E_ALL	E_ERROR & E_WARNING
register_globals	Off	Off
register_long_arrays	Off	Off
register_argc_argv	Off	Off
auto_globals_jit	On	On
magic_quotes_gpc	Off	Off
extension_dir	"./"	"C:\php\ext"
enable_dl	On	Off
cgi.force_redirect *	1	0
fastcgi.impersonate *	1	1
SMTP	localhost	[server name or IP address]
smtp_port	25	[server's smtp port number]
sendmail_from *	me@example.com	[administrator@acmehomes.com.au]
odbc.defaultlrl	4096	65536
session.auto_start	0	0
* If a semi-colon (;) appears at the beginning of the line, users MUST remove it. ** Ensure the uncommented error_reporting field (with no semi-colon (;)) and not the commented ;error_reporting field (with semi-colon (;)) is updated.

...

Open Data Sources (ODBC).
Select the System DSN
Click the Add The Create New Data Source dialog will be displayed.
Select SQL Native Client for the SQL Server version being used.
Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.
Enter the following details:
1. Name: FworkSQLECM
2. Description (optional): Enter a description for the database connection. For example, Framework ECM.
3. Server: Select the SQL Server from the Server drop-down list.
  OR
  Enter the SQL Server name.
  Info
  
  If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS
Click the Next
Click the Next
Tick Change the default database to.
From the drop-down list select: FworkSQLEcm
Click the Next
Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.
Click the Test Data Source...
If successful, click the OK
Click the OK The ODBC Microsoft SQL Server Setup dialog will close.
Click the OK The Data Sources (ODBC) dialog will close.

...

Open Data Sources (ODBC).
Select the System DSN tab.
Click the Add button. The Create New Data Source dialog will be displayed.
Select SQL Native Client.
Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
Enter the following details:
1. Name: FworkSQLLic
2. Description (optional): Enter a description for the database connection. For example, Framework Licence.
3. Server: Select the SQL Server from the Server drop-down list.
  OR
  Enter the SQL Server name.
  info
  
  If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS
Click the Next button.
Click the Next button.
Tick Change the default database to.
From the drop-down list select: FworkSQLLic
Click the Next button.
Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
Click the Test Data Source... button.
If successful, click the OK button.
Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
Click the OK button. The Data Sources (ODBC) dialog will close.

...

Versions Compared