Pesquisar

質問
· 2020年1月10日

MSSQL ODBC Connection Error (NativeError: [11001] )

Hello, I need to use IRIS to connect to an MSSQL base.
It has to be done via ODBC, I can't use JDBC at this time by client option.

I am trying to use Microsoft Driver
libmsodbcsql-13.1.so.9.2

But I can't, my attempts result in:
Connection failed.
SQLState: () NativeError: [11001] Message:

I have done all DSN configuration, and my configuration is listed in SQL Gateway Connections. I know it's working, because when I run a test with isql I have the information that connects to the bank.

This is my IRIS and Server configuration:
IRIS for UNIX (Ubuntu Server LTS for x86-64) 2018.1.1 (Build 643U)

3 Comments
ディスカッション (3)2
続けるにはログインするか新規登録を行ってください
質問
· 2019年12月20日

CSP front page to allow users to alter multidimensional tables

I have a case where I have an external table that lives out in MS SQL. Using Ensemble Security functions has anyone created a csp or cls page that acts like a portal to allow users to Update a multidimensional table without knowing SQL? I could clone the EnsPortal.LookupSettings but that was made for LUT which are only 2 columns.

 

 

I know its a long shot but trying to see if there was anything off the shelf that I can use to help meet the requirements of this project.

4 Comments
ディスカッション (4)2
続けるにはログインするか新規登録を行ってください
質問
· 2019年12月19日

The message in Ensemble has been retained for only 20 days, but the amount of data is still more than 300G. What should be done to reduce the storage capacity?

The message in Ensemble has been retained for only 20 days, but the amount of data is still more than 300G. What should be done to reduce the storage capacity?
 

3 Comments
ディスカッション (3)0
続けるにはログインするか新規登録を行ってください
質問
· 2019年12月18日

Connecting Remote server(Cache) to Power BI

Hi Folks,

I would like to visulaize the tables and data on Power BI, so I try to connect the romote server to Power BI to access the tables and data of remote server. I can able to connect that remote server to our Studio also able to view class files. 
But I couldn't able to connect the remote server to power BI. I'm getting the below error while click on the tables 

"Expression.Error: This native database query isn't currently supported" 

 So now I'm in need of help

 

Thanks,

Vikram 

8 Comments
ディスカッション (8)1
続けるにはログインするか新規登録を行ってください
質問
· 2019年12月11日

Issue with parsing a form variable of a HTTP POST request

Hi everyone, 

I am currently sending an HTTP POST request to an  EnsLib.HTTP.Service service (which has an EnsLib.HTTP.InboundAdapter associated). 

Here the request URL: http://10.41.11.210:57772/csp/healthshare/dce/POSTServiceClass.cls?rpyTo...

From the documentation I have read (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=EHTTP_inbound) I get that the form variables are written into the request body in case of a POST. I have also implemented the OnInint() is this way to enable the form variables parsing: 

 Method OnInit() As %Status
{
    Set ..Adapter.ParseBodyFormVars=1
    Quit 1
}

The OnProcessImput of the service is implemented in this way: 

Class POSTServiceClass Extends (EnsLib.HTTP.Service, HS.Util.Trace.Helper)
{
Parameter CONTENTTYPE = "text/xml";
Property TargetProcess As %String(MAXLEN = 250) [ Required ]; .
Property isServerFault As %Boolean;
Method OnInit() As %Status
{
    Set ..Adapter.ParseBodyFormVars=1
    Quit 1
}
Method OnProcessInput(pInput As %GlobalCharacterStream, Output pOutput As %GlobalCharacterStream, ByRef pHint As %String) As %Status
{
set ..isServerFault = $$$YES  // Server Fault by default #dim token As %String
if '$isObject(pInput) || (pInput.Size = 0) 
{
set ..isServerFault = $$$NO  
quit $$$ERROR($$$GeneralError, "Null request")
}
#dim inMsg As HS.Message.XMLMessage = ##class(HS.Message.XMLMessage).%New()
set inMsg.ContentStream=pInput
#dim outMsg As HS.Message.XMLMessage = "" 
#dim sc As %Status = ..SendRequestSync(..TargetProcess, inMsg, .outMsg) 
if $$$ISERR(sc) quit sc // check if we have a good response
if '$isObject(outMsg) || 'outMsg.%Extends("HS.Message.XMLMessage") quit $$$ERROR($$$GeneralError, "Null or incorrect response") set pOutput = outMsg.ContentStream
quit $$$OK
}

I was expecting to find my form variable (rpyToken) into the contentStream of the isMsg XMLMessage but there isn't. 

Can someone explain me what is my mistake?

Thank you in advance.

1 Comment
ディスカッション (1)1
続けるにはログインするか新規登録を行ってください