dipeshkhatiwada / odbc-connector
ODBC Driver for Laravel 8.* to connect with external database
Requires
- php: 8.*
- ext-pdo: *
This package is auto-updated.
Last update: 2024-10-05 18:41:45 UTC
README
A simple ODBC driver for Laravel 8.*. Requires PHP version 8+.
Prerequisites
Enable the pdo_odbc
PHP extension.
For other database engines (for instance MS SQL Server), you'll need to install the appropriate PHP extension(s).
Installation
composer require dipeshkhatiwada/odbc-connector
Laravel will automatically discover the service provider.
Configuration
In your database.php
config, configure your connection using the odbc
driver:
'odbc-connection' => [ 'driver' => 'odbc', 'dsn' => env('ODBC_DSN'), 'host' => env('ODBC_HOST'), 'database' => env('ODBC_DB'), 'username' => env('ODBC_USERNAME'), 'password' => env('ODBC_PASSWORD'), ],
Usage
Use the connection like any other, via the query builder or with Eloquent.
For Eloquent, you'll need to specify the model's connection:
class Users extends Eloquent {
/** @var string */
protected $connection = 'odbc';
}
Connection String
You may need to use some trial and error to figure out what your connection string should look like. Consult your vendor's database documentation.
It could be a connection path:
'dsn' => 'odbc:\\\\path\to\my\database',
Or a connection name:
'dsn' => 'odbc:\\\\my-connection-name',
Or something as simple as:
'dsn' => 'odbc:dbname',
For SQL server, you'll need to specify the DSN, the user, and the password. For example:
'dsn' => 'sqlsrv:Driver=ODBC Driver 18 for SQL Server;Server=tcp:localhost,1433;TrustServerCertificate=1;Encrypt=1;' 'username' => 'sa', 'password' => 'my-super-secret-password',
Contributions & License
Contributions are hearty welcome.
MIT Licensed.You can wish to modify.