Inital configuration of SQL server in Dream factory - SAGE

Connecting to SQL
1

Hi all,

I’m new to Dream factory and was hoping I could get some help with this;

Both Dream factory and SQL Server are installed on the same machine, however I cannot get them to connect… service config is as follows -

Host - 127.0.0.1
port - 1433
database - demo
username - **
password - **

I then have gone onto the api docs to try and do a get of one of the tables however I keep getting ‘500’ error codes for internal fault.

The setup is basically (SAGE <-> SQL Server <-> Dream factory <-> Salesforce)

Has anybody done any kind of Sage integration or something similar?

Thanks!

1 Like
2

Hello,
You need to install php PDO drivers https://wiki.dreamfactory.com/DreamFactory/Installation/Databases/SQLServer

2 Likes