laravel-sqlserver

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 submit a pull request on the README or open an issue with additional commands specifying which distro you are using and 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

TechScope\SqlServer\SqlServerServiceProvider::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

• For the ODBC Driver MAKE SURE TO REPLACE THE SQUARE BRACKETS ([]) WITH CURLY BRACES ({}) IN config/database.php
• You must use the host, database, username, password, port properties to properly setup the DSN string for the ODBC Connection
• any additional parameters you'd like to use for the connection can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-connection-string-keywords-with-sql-server-native-client
  • NOTE: the Address, Addr, Database, Server, UID, PWD, Network, Net, DSN and Database properties cannot be used here and will be ignored as they are already specified the Laravel way