Error in homestead with SQL Server driver when saving laravel session (DB-Library (as ISQL) or ODBC version 3.7)

Navigation
0

I am saving my Session in the database using laravel with SQL Server in homestead (Ubuntu) and at the moment of entering the system it shows me this error:

  

SQLSTATE [HY000]: General error: 4004 Unicode data in a Unicode-only   collation or ntext data can not be sent to clients using DB-Library   (such as ISQL) or ODBC version 3.7 or earlier. [4004] (severity 16)   [select top 1 * from [sessions] where [id] =   'nbcccjhQEpucEpLoecby3FHrgkQ04TOXNJbieaZL'] (SQL: select top 1 * from   [sessions] where [id] = nbcccjhQEpucEpLoecby3FHrgkQ04TOXNJbieaZL)

Any suggestions?

    
asked by Francisco Quijada 20.03.2018 в 17:37
source

1 answer

1

I comment on the solution in case it helps someone in the future:

  • Enter homestead
  • Making vagrant ssh
  • Go with the cd command to the / etc / freetds directory
  • Open the file freetds.conf with the following command: sudo nano freetds.conf
  • Change the line:
    •   

    #TDS protocol version

         

    tds version = 4.2

    for

      

    tds version = 8.0

  • Restart the server with the command: service nginx restart
    • answered by 20.03.2018 / 18:01
    source
    Server does not recognize function date_create_from_format How to upload files from an ftp server on my website? [closed]