Use phpgrid with SQL Server (microsoft)

QuestionsUse phpgrid with SQL Server (microsoft)
abdelilah dourhmani asked 1 year ago

It’s possible to use phpgrid for mssql?

2 Answers
Abu answered 1 year ago

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.

abdelilah answered 1 year ago

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

Your Answer

12 + 5 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?