I am using Dreamfactory 2.1 and Laravel Homestead for my VM.
When I create a new service for SQL Server I am receiving the following error:
Api Error
Required extension or module ‘mssql’ is not installed or loaded.
Database for the service is set to SQL DB.
Here is my connection string: dblib:host=localhost:1433;dbname=database;charset=UTF-8
Has anyone been able to get Dreamfactory to successfully work with SQL Server using Laravel Homestead?
I haven’t used homestead at all, but connecting to MS SQL in linux requires the php sybase driver.
In ubuntu/debian this is sudo apt-get install php5-sybase
https://wiki.dreamfactory.com/DreamFactory/Installation#Additional_Drivers_and_Modules
Thank you for this. After additional searching it looks like the need the sybase drivers for PHP 7.
I have installed them using the following command:
sudo apt-get install php7.0-sybase freetds-common libsybdb5
I am still getting the error though. Does Dreamfactory work with PHP 7?
I think that I am encountering the same issue described in: Unable to connect to SQL Server 2012 on Windows with DF2.0 Beta 2 It is looking for the mssql driver but I have the dblib driver selected in my connection string.
I followed the steps in https://wiki.dreamfactory.com/DreamFactory/Installation/Databases/SQLServer for Linux using the apt-get command in my reply above but used the php7.0-sybase package instead. Still not working, any input would be appreciated.
Thank you.