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:h…

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 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.

Creating new SQL Server service

Connecting to SQL

dnewbytricore February 11, 2016, 9:12pm 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.

Topic		Replies	Views
MS SQL: Required PDO driver 'sqlsrv' is not installed or loaded properly Connecting to SQL	6	6779	October 14, 2015
Issues connecting to Remote SQL Connecting to SQL	4	3979	October 9, 2014
DreamFactory error 'CDbConnection failed to open the DB connection.' in SQLServer DB Connecting to SQL	4	4256	December 4, 2014
Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4 Connecting to SQL	15	7380	January 6, 2016
Inital configuration of SQL server in Dream factory - SAGE Connecting to SQL	1	2628	November 7, 2016

Creating new SQL Server service

Related topics