tck/odbc

ODBC Connector for Laravel

Laravel ODBC Connector

This is a simple ODBC connector for Laravel 4/5., _(*1)

Installation

Add this to the require section in your composer.json file, _(*2)

"tck/odbc": "dev-master"

In your config/app.php file add the Service Provider to the service providers array like so..., _(*3)

'TCK\Odbc\OdbcServiceProvider',

Now in your config/database.php you will need to add your connection details, it'll look something like this..., _(*4)

'odbc'   => [
    'driver'   => 'odbc',
    'dsn'      => 'odbc:DB_CONNECTION_STRING', //
    'host'     => 'DB_HOST',
    'database' => 'DB_NAME,
    'username' => 'DB_USERNAME',
    'password' => 'DB_PASSWORD',
],

Custom Grammar

To use SQL Server or other database engines, set the grammar in the config:, _(*5)

'odbc'   => [
    ...
    'grammar' => [
        'query' => Illuminate\Database\Query\Grammars\SqlServerGrammar::class,
        'schema' => Illuminate\Database\Schema\Grammars\SqlServerGrammar::class,
    ],
],

Usage

Now in your app you can do something like..., _(*6)

$data = DB::connection('odbc')->get('tableName')->all();

Alternatively, in an Eloquent model you could something like this, _(*7)

class Users extends Eloquent {

    protected $connection = 'odbc';
}

DB_CONNECTION_STRING - Something to note

Dependant upon your database configuration, I personally had some difficulty in working out what the DB_CONNECTION_STRING needed to be., _(*8)

This was some trial and error (with a hell of a lot of Googling!) but you could either use a path, something like..., _(*9)

'dsn'      => 'odbc:\\\\path\to\my\database',

Or a connection name, _(*10)

'dsn'      => 'odbc:\\\\my-connection-name',

Hopefully, this will help you!, _(*11)