Tuesday, March 14, 2017

Laravel 5 and MS SQL server connection error

new to laravel framework, I am running multiple database connections for a project I am working on. Just a simple test against one of the mysql instance,

<p></p>

gives a simple dump but when run simmilar test against the ms sql server 2012, it errors out

<p></p>

The error is:

ErrorException in helpers.php line 519:
Method Illuminate\Support\Collection::__toString() must return a string value

my db config is similar to other examples I have seen posted online.

'sqlsrv' => [
        'driver' => 'sqlsrv',
        'host' => env('DB_HOST', 'SQL3.company.ca'),
        'database' => env('DB_DATABASE', 'test'),
        'username' => env('DB_USERNAME', 'test'),
        'password' => env('DB_PASSWORD', '#######'),
          'collation' =>  'SQL_Latin1_General_CP1_CI_AS',
          'charset'   =>  'latin1',
        'prefix' => '',
],

Did I set up something wrong? any direction I should be looking at?



via wpvic

Advertisement