Problem with SQL Server connection

3

I have a PHP system hosted on a Linux server that queries a SQL Server database through mssql . Works perfectly on the server. I needed to make some changes to this system, so I put it in my localhost and it was working ok. Out of all, queries with mssql stopped working, returning ERR_EMPTY_RESPONSE on pages.

The connection:

$host='******';
$user='***';
$database='****';
$pass='****';

$con=mssql_connect($host, $user, $pass) or die ("Erro de conexão com o banco de dados"); 
mssql_select_db("$database") or die ("Erro ao selecionar banco de dados");

The connection does not return any errors. But when I run a query like this:

 $sql=mssql_query("SELECT DES_MOVIMENTO, VAL_PRODUTO_MOVIMENTO
 FROM supervisor.MOVIMENTO_ESTOQUE 
 WHERE COD_PRODUTO='1254'") 
 or die ('Erro de conexão com o SIGA');

This error appears:

PHPINFOshowsthesedirectives:

    
asked by anonymous 17.03.2016 / 12:31

1 answer

1

The problem has been solved by reinstalling the php-mssql module on my local server.

    
18.03.2016 / 13:39