MS SQL connection


#1

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.


#2

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.