i want to connect db in another system through odbc connection, not in my loca system.what to do?
Hello,
You can specify server location, in connection setting param:
e.g. to connect remote sql server db – $db_conf["server"] = "34.234.33.53";
$db_conf = array();
$db_conf["type"] = "mssqlnative";
$db_conf["server"] = "34.234.33.53";
$db_conf["user"] = null;
$db_conf["password"] = null;
$db_conf["database"] = "master";
…
$g = new jqgrid($db_conf);
Few other examples:
$db_conf = array();
$db_conf["type"] = "odbc_mssql";
$db_conf["server"] = "Driver={SQL Server};Server=localhost;Database=northwind;";
$db_conf["user"] = "user";
$db_conf["password"] = "pass";
$db_conf["database"] = null;
$db_conf = array();
$db_conf["type"] = "ado_mssql";
$db_conf["server"] = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=flipper;DATABASE=ai;UID=sa;PWD=;";
$db_conf["user"] = null;
$db_conf["password"] = null;
$db_conf["database"] = null;