Helo,
Yes, It’s supported. Configuration depends how you have setup php / sql-server connectivity.
Sample code here: https://www.gridphp.com/demo/demos/loading/db-layer-sqlsvr.phps
PS: If you show a working php code that connects to sql server using php, then we can suggest datagrid db configuration.
i try it and i have a error
my code:
$db_conf = array();
$db_conf[“type”] = “mssqlnative”; // or mssql
$db_conf[“server”] = “192.168.4.55”; // ip:port
$db_conf[“user”] = “sa”;
$db_conf[“password”] = “Proxy@2023”;
$db_conf[“database”] = “DB_PROXY”;
————————————————————–
error:
Please check your database connection configuration. SQLState: 08001 Error Code: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was provided by an authority that is not trusted. SQLState: 08001 Error Code: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]Client could not establish connection SQLState: 08001 Error Code: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The certificate chain was provided by an authority that is not trusted. SQLState: 08001 Error Code: -2146893019 Message: [Microsoft][ODBC Driver 18 for SQL Server]Client could not establish connection