All
Accepted answers
Vivek Ranjan · Jan 8, 2018 go to post

Port 57772 is for local host. The remote hosted instance runs on port 80(xyz.x.edu)

Vivek Ranjan · Jan 2, 2018 go to post

Works like charm in local windows machine.  I was trying to configure the same where the ensemble instance is hosted on Linux machine and there is no path for .net gateway service. 

There isn't any folder with dotnet where  DotNetGatewaySS.exe can be found.

 

InterSystems\Ensemble20162\dev\dotnet\bin\v4.0.30319

Vivek Ranjan · Dec 10, 2017 go to post

I tried your quey and it ran successfully.

SELECT * FROM Config.IO WHERE ID IN ('1||1||9852553062' , '1||1||9852553061' ) order by 1 desc

The error you got seems very generic. Kindly check the table again.

The SQLCODE -400 error “Fatal error occurred” is a general error. It is generated when a more specific SQLCODE error code is not available. 

Vivek Ranjan · Nov 24, 2017 go to post

Thanks @Robert Camper. 

If the DATEPART() always takes logical mode value irrespective of display mode selected in SQL query viewer, I was wondering there is implicit conversion of  Timecreated Column(column1 in abobe example) to the mode selected in SQL query window.