My config using db-layer-sqlsrv.php
$db_conf = array();
$db_conf[“type”] = “mssql”; // or mssql mssqlnative
$db_conf[“server”] = “220.127.116.11:1433”; // ip:port
$db_conf[“user”] = “sa”;
$db_conf[“password”] = “xxxxxx”;
$db_conf[“database”] = “BDSis”;
$g->table = “[BDSis].[dbo].[CONTACTOS]”;
$g->select_command = “Select * from CONTACTOS”;
I am geting blank grid, no errors on load. What i am doing wrong?
After activating display errors, i get this error:
Warning: mssql_connect(): Unable to connect to server: 18.104.22.168 in /var/www/html/phpgrid/lib/inc/adodb/drivers/adodb-mssql.inc.php on line 614
I can connect to server with Microsoft sql server manager and Navicat
After checking mssql_connect is deprecated, actually for new versions of php and microsoft sql server drivers function is sqlsrv_connect. Is there any update on phpgrid for this?
It is recommended to use ‘mssqlnative’ extension instead of ‘mssql’.
The older one is outdated by Microsoft & PHP.
To install: https://www.phpgrid.org/faqs/#74
Abu Ghufran - Dev Team
Grid 4 PHP Framework
If you have extension installed and enabled, You only need to change type to:
$db_conf[“type”] = “mssqlnative”;
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?