使用odbc雄辩的外部laravel PHP7

Question

I am using eloquent outside laravel. I have my own PHP application. This is what i am using https://github.com/illuminate/database

My config is as following

$settings3 = array(
'driver'    => 'odbc',
'dsn' => "Driver={SQL Server};Server={serverName};Trusted_Connection=true;Database=telesur_mis;",
'username' => 'user',
'password' => 'user',);

$capsule->addConnection($settings3,'teleappframework');

After executing this code I am getting the following error

Fatal error: Uncaught InvalidArgumentException: Unsupported driver [odbc]

I have PDO ODBC installed, i have also tested pdo odbc connection outside of eloquent. The reason for using ODBC is, because i am using PHP7 and currently there is no PDO extension for SQL Server.

Can anyone help me on this?

Answer 1

i would download FreeTDS and just use the regular sqlsrvr driver it works like a charm (if you are on a unix env) there is a lot of posts on how to configure it etc just look it up.