MS SQL issue in GUI

Connecting to SQL
1

Hi

I am running Dreamfactory 2.1.0 now I have a very strange issue, I am unable to connect one of my SQL server through GUI/API. Here is the error

“message”: “Failed to connect to database.\nConnection failed to open the DB connection: SQLSTATE[01002] Adaptive Server connection failed (severity 9)”,

But from command line it is working using tsql

root@ip-10-0-200-98:~# /opt/bitnami/common/bin/tsql -S dbserver -U sqluser -P vTest91019

locale is “en_US.UTF-8”
locale charset is “UTF-8”
using default charset “UTF-8”
1>

As you can see there is no issue with command line. Would you please help me that how I can fix this issue?.

2

Hello @umardraz

I know this error occurred close to a year ago, but were you able to solve the issue? If you have not, you need to make a change in your PHP file. You must fix your connection string. Change dlib to sqlsrv and host to Server

Hope it helps