laradevs/odbc

It is a component for connect ODBC with laravel.

v1.0.1 2020-06-06 06:08 UTC

Requires

• php: >=7.2
• ext-curl: *
• ext-json: *
• illuminate/support: ^5.8|6.*|7.*

Requires (Dev)

• orchestra/testbench: ^3.5|^4.0|^5.0|^6.0
• phpunit/phpunit: ^9.0

MIT

• Ernesto G. Liberio Vera

README

Laravel ODBC Connector

This is a simple ODBC connector for Laravel.

Installation

Add this to the require section in your composer.json file

composer require "laradevs/odbc"

Now in your config/database.php...

......
'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:

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