rui_mashita/laravel-dblib-odbc-sqlserver

PDO DBLIB or PDO ODBC SQL Server Driver for Laravel 4

dev-master 2015-02-06 16:56 UTC

Requires

• php: >=5.3.0
• illuminate/database: ~4.2
• illuminate/support: ~4.2

MIT

• Takuya Wakisaka

• odbc
• laravel

README

Requirements

• PHP 5.3+
• Laravel 4.2.*

Installation

Add rui_mashita/laravel-dblib-odbc-sqlserver as a requirement to composer.json:

{
    "require": {
        "rui_mashita/laravel-dblib-odbc-sqlserver": "dev-master"
    }
}

service provider registration in you app.php file under app\config path from Laravel project root folder.

'DblibOdbcSqlServer\Database\ServiceProvider',

Configuration

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

    'connections' => array(

        // .. Existing config here ..

        // ODBC config example
        'odbc' => array(
            'driver' => 'odbc',
            'dsn' => 'Driver={ODBC Driver};',
            'username' => 'foo',
            'password' => 'bar',
            'database' => '',
        ),

        // DBLIB config example
        'dblib' => array(
            'driver' => 'dblib',
            'host' => '172.16.0.223',
            'port' => '1433',
            'username' => 'sa',
            'password' => 'password',
            'database' => 'testtest',
        ),
    ),