Update_all.php and MSSQL database

Suite and Optimus Suite 5
#1

I am trying to update data from a grid using the update_all.php sample code.

I am trying to update a MSSQL database and not a MySQL database.

I am getting the following error:

PHP Warning: mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Is there anyway to configure this file to use it with a MSSQL database?

Any help would be greatly appreciated. If you need any additional info to assist me I will gladly provide it.

Thanks in advance.

#2

You need to change mysql commands with mssql ones

php.net/manual/en/book.sqlsrv.php

You can check connector’s package, it has samples for main DB types, include MsSQL DB

dhtmlx.com/docs/products/dhtmlxConnector/

docs.dhtmlx.com/connector__php__ … ample.html