Trying to connect Dreamfactory 2.0a (from github) to MS SQL, from Ubuntu 14.04 LTS.
Have added the following extensions to php.ini:
extension=pdo_dblib.so
extension=mssql.so
When I run php -i |grep PDO I see some signs that PDO driver for FreeTDS is working.
PDO
PDO support => enabled
PDO drivers => firebird, dblib, mysql
PDO Driver for FreeTDS/Sybase DB-lib => enabled
PDO_Firebird
PDO Driver for Firebird/InterBase => enabled
PDO Driver for MySQL => enabled
Inside PHP itself, in a test.php, I enumerate PDO sources:
<?php foreach (PDO::getAvailableDrivers() as $driver) { echo $driver.''; } ?>
Hereās the output:
firebird
dblib
mysql
All that, and yet, I can not connect to an MS SQL database, in Dreamfactory. I thought if I get PHP set up, Dreamfactory should work with MS sql.
What else do I have to do? Is there some configuration file changes required inside the dreamfactory/platform/config to make MS SQL connections? I get the error that required PDO driver sqlsrv is not installed or loaded properly.
W