Creating new SQL Server service


#1

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?


#2

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

http://wiki.dreamfactory.com/DreamFactory/Installation#Additional_Drivers_and_Modules


#3

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?


#4

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.


#5

I followed the steps in http://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.