Can connect and GET data from MS SQL Server from Dreamfactory.

Using dblib (library/driver)

When I try to use the createRecords method, I get a strange error.

If I try to insert records into a table called "iyer\_test", I get an error that says table "EMP\_OnRolls" does not exist in database.

Why do you think DSP should report an unrelated table as non-existent?

I am trying all this from the Swagger UI - so authentication, session and all other prerequisites are hopefully taken care of.

Service definition : Database Driver : dblib:host=del-xxxxxxxx:1433;dbname=utilities

I can connect to the database server with the user name supplied and the user has rights to read/write/modify rows in the tables. Confirmed with SQL Server Management Studio.

In the Swagger UI, if I enter the table name as "dbo.iyer\_temp" I get an error that says dbo.iyer\_temp table does not exist.

The body I pass to the createRecord method is {

"record": [ {
 "lname" : "Iyer",
 "fname" : "K Y
 }]
}

The table iyer\_temp has an id column called "id".

Why should the DSP report a strange table as not available?

Thanks in anticipation

Best wishes

Iyer