rtroncoso / odbc-driver by rtroncoso
forked from ccovey/odbc-driver

Laravel 5.0 ODBC Driver
26
0
2
Package Data
Maintainer Username: rtroncoso
Maintainer Contact: rod.tronco@gmail.com (Rodrigo Troncoso)
Package Create Date: 2015-11-23
Package Last Update: 2015-12-02
Home Page:
Language: PHP
License: Unknown
Last Refreshed: 2024-12-19 03:22:52
Package Statistics
Total Downloads: 26
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 0
Total Watchers: 2
Total Forks: 1
Total Open Issues: 0

l5-odbc-driver

Laravel 5.0 ODBC driver

Installation

To Install this in your Laravel 5.0 app, open composer.json and add:

"require": {
  "garylocke/odbc-driver": "dev-master"
}

And then run:

composer update

This will download the required package from Packagist.org.

Then, in your app/config directory, open app.php and find:

Illuminate\Database\DatabaseServiceProvider::class

And replace it with:

Ccovey\ODBCDriver\ODBCDriverServiceProvider::class

Finally, be sure to add the odbc driver with connection information to the connections array in config/database.php file like so:

    'connections' => [
        'odbc' => [
            'driver' => 'odbc',
            'dsn' => 'Driver={iSeries Access ODBC Driver};System=my_system_name;',
            'grammar' => 'DB2',
            'username' => 'foo',
            'password' => 'bar',
            'database' => '',
        ],
    ],

Note that database is a required value in the array.

Notes

To add a custom grammar, add your file to ODBCDriver/Grammars with the name you would like to use (currently there is a DB2 grammar file if you would like a reference). Then, in your odbc config array, add the class name to the grammar key. If you would like to submit a grammar for use in the package, please submit a pull request and I will get it in asap.

If you would like to use a Laravel provided file, just add that instead. For example, if you want to use SQL Server Gramamr instead, you can add like so:

'odbc' => [
    'driver' => 'odbc',
    'dsn' => 'some driver',
    'grammar' => 'SqlServerGrammar',
    'username' => 'foo',
    'password' => 'bar',
    'database' => '',
],