LARAVEL with MSSQL SERVER.md

Microsoft ODBC driver for SQL Server (Ubuntu)

sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list

sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18

SQLSRQ and PDO_SQLSRV

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
sudo su

# mind your php version
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.1/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/8.1/mods-available/pdo_sqlsrv.ini

sudo phpenmod -v 8.1 sqlsrv pdo_sqlsrv

DATABASE CONFIG IN LARAVEL (config/database.php)

'sqlsrv' => [
    'driver' => 'sqlsrv',
    'host' => env('DB_HOST', 'localhost'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'charset' => 'utf8',
    'prefix' => '',
    'encrypt' => 'yes',
    'trust_server_certificate' => true,
],

LARAVEL could not load driver

# mind your php version
sudo apt -y install php8.1-sybase