I have an application in laravel connecting in the database on a SQL Server when I will make a query of all the products I am getting the error
SQLSTATE[HY000] General SQL Server error: Check messages from the SQL Server (severity 14) (SQL: select * from [produto])
database.php
'sqlsrv' => [
'driver' => 'sqlsrv',
'host' => env('DB_HOST', 'xxx.xxx.xxx.xxx'),
'port' => env('DB_PORT', '1433'),
'database' => env('DB_DATABASE', 'MpiWeb'),
'username' => env('DB_USERNAME', 'xxxxxx'),
'password' => env('DB_PASSWORD', 'xxxxxx'),
'charset' => 'utf8',
'prefix' => '',
],
Woocontroller.php
public function mpiweb(){
$listaprodutos = Everest::all();
return $listaprodutos;
}