MS SQL connection


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

While in you case, this is a sqlsqrv driver

You can try to do the next

a) grab db_sqlsrv.php from here … 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) {
$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);

The spreadsheet is not tested with SqlSrv data driver, so I’m not sure that above will work correctly.