I previously posted this in the dhtmlxSpreadsheet, jsMessage discussion area and never received any response.
Any suggestions or help in resolving this would be greatly appreciated.
Spreadsheet is using mssql driver
docs.php.net/manual/en/intro.mssql.php
While in you case, this is a sqlsqrv driver
docs.php.net/manual/en/book.sqlsrv.php
You can try to do the next
a) grab db_sqlsrv.php from here github.com/DHTMLX/connector-php … r/codebase, and place it in the installer/src/codebase/php
b) in index.php change <option value=“MsSQL” to <option value=“SQLSrv”
c) in installer/installer.php add one more method
[code] private function sqlsrvDBConnect($db_host, $db_port, $db_user, $db_pass, $db_name) {
require_once(’./installer/src/codebase/php/db_sqlsrv.php’);
$serverName = “$db_host, $db_port”; //serverName\instanceName, portNumber (default is 1433)
$connectionInfo = array( “Database”=>"$db_name", “UID”=>"$db_user", “PWD”=>"$db_pass");
return sqlsrv_connect( $serverName, $connectionInfo);
}[/code]
The spreadsheet is not tested with SqlSrv data driver, so I’m not sure that above will work correctly.