PHP install/upgrade
...
Packages to be installed
'PHP 7.13.7 X (x86) for IIS Express'
'Microsoft Drivers 4.3 (x86) for PHP v7.1 3 for SQL Server in IIS'
'Windows Cache Extension 2.0 (x86) for PHP 7.1 3 in IIS Express (Automaitcally selected when PHP is selected)
...
| FieldName | DefaultSetting | Required Setting |
|---|---|---|
| sql.safe_mode | Off | Off |
| max_execution_time | 300 | 60 |
| error_reporting | E_ALL & ~E_DEPRECATED & ~E_STRICT | E_ERROR & E_WARNING |
| register_argc_argv | Off | Off |
| auto_globals_jit | On | On |
| extension_dir * | "./" | "./" |
| enable_dl | Off | Off |
| cgi.force_redirect * | 1 | 0 |
| fastcgi.impersonate * | 1 | 1 |
| SMTP | localhost | [servername or IP address] |
| smtp_port | 25 | [server'ssmtp portnumber] |
| sendmail_from * | me@example.com | [administrator@acmehomessupplierconnect@yourdomainname.com.au] |
| odbc.defaultlrl | 4096 | 65536 |
| session.auto_start | 0 | 0 |
* If a semi-colon (;)appears at the beginning of the line, it MUST be removed.
Find the Windows Extensions Extensions section at the bottom of the php.ini file
Add the following
- extension=php_odbc.dll
Save the php.ini file
Configure Firewall Settings
...
Modify the following lines with the DSN Name, Username and Password you used to create the ODBC Connection above.
If the SQL password to be added contains a dollar sign ($), the double quotes " must be replaced with single quotes, e.g. "P@$$word" → 'P@$$word'
$dsn = "FworkSQLEcm"; // ODBC connection of database.
...