Use ODBC to connect with your SQL Server instances from Laravel 5+

Use ODBC to connect with your SQL Server instances from Laravel 5+

README

Use ODBC to connect with your SQL Server instances from Laravel 5+.

This package allows you to use the OFFICIAL Microsoft SQL Server ODBC driver to
connect to a Microsoft SQL Server database.

Disclaimer: all Bash commands you will see here are examples for RHEL/CentOS Yum package manager.
If you would like to help make these docs more friendly with other distros, please make sure to either
open an issue with additional commands specifying which distro you are using. I’ll then update the README
docs.

Dependencies

UnixODBC

sudo yum install -y unixodbc

PHP’s ODBC PDO driver

sudo yum install -y php-odbc

Microsoft’s SQL Server Driver

You can find specific instructions for your distro here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

Package Installation

Install with composer

composer require techscope/laravel-sqlserver:dev-master

Add the Service Provider to config/app.php

TechScopeSqlServerSqlServerServiceProvider::class

Make sure to update your config/database.php file

'domdb' => [
            'driver'        => 'sqlsrv',
            'odbc_driver'   => '{ODBC Driver 13 for SQL Server}',
            'host'          => env('DB_HOST', 'localhost'),
            'database'      => env('DB_DATABASE', 'forge'),
            'username'      => env('DB_USERNAME', 'forge'),
            'password'      => env('DB_PASSWORD', ''),
            'port'          => env('DB_PORT', '1433'),
            'TrustServerCertificate' => 'yes'
        ],

IMPORTANT NOTES:

  • driver should be set to sqlsrv. This uses the preexisting SQL Server grammar that ships with Laravel.
  • odbc_driver should be the name of the ODBC Driver as it appears in /etc/odbcinst.ini. Example:
[ODBC Driver 13 for SQL Server] <--- USE THIS LINE OR SIMILAR DEPENDENDING ON WHICH VERSION YOU INSTALL
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.8.0
UsageCount=1

Source

Add a Comment

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *