Find

I'm in the process of setting up InterSystems IRIS for HealthShare with database mirroring, and I’d appreciate some guidance around how to handle an existing ODBC connection in this new setup.

Scenario:

We currently have a system running IRIS for HealthShare that external systems connect to via ODBC (using a standard connection string with hostname and port).
We're now configuring mirroring on this system — it will become one of the mirror members (Primary/Backup).
The external system using ODBC will not be part of the mirror, but it needs to continue accessing the IRIS instance seamlessly during failover.

Questions:

How should the existing ODBC connection be modified (if at all) to work properly with mirroring?
- Can ODBC be configured with a mirror-aware connection string?
- Or should we set up a Virtual IP (VIP) for the mirror and point the ODBC client to that and how would I make this mirror aware?
What are the best practices to ensure high availability for ODBC clients during mirror failover?
Are there specific considerations for HealthShare environments, especially with regard to externally connected systems (via ODBC) that are not mirror-aware?

Any official guidance, sample configurations, or insight from similar deployments would be greatly appreciated.

Thanks in advance!

Best regards,
Fraser

3 new Comments

Discussion (3)3

Question

Touggourt · May 1

#InterSystems IRIS

Hi Guys,

How can I use this same objectscript principle in embedded python to get the value of each field in my loop?

s sql="SELECT ID, Name, Age FROM Sample.Person WHERE Age="_Myage

Set RS=##class(%ResultSet).%New()

Set Ret=RS.Prepare(sql)

Set Ret=RS.Execute()

While RS.Next()

{

Set name=RS.GetData(2)

}

it should be similar to this example which lists the whole row but how can I get the value of each field or if I can use GetData?

Thanks

2 new Comments

Discussion (2)1

Digest

Kellin Zhang · May 1

#Developer Community Official #Digest

您好，欢迎阅读四月 2025 开发人员社区通讯。

统计信息

✓ 四月发布了 2 篇新帖子：

– 2篇新文章

✓ 四月有 17 位新成员加入
✓ 所有时间发布了 2,375 篇帖子
✓ 所有时间有 2,183 位成员加入

最高职位

如何构建代理人工智能 RAG 应用程序：分步指南

按Lilian Huang

Iris-AgenticAI: 基于OpenAI智能体SDK驱动的企业自动化多智能体工作流平台

按Lilian Huang

开发者社区回顾, 三月 2025

按Kellin Zhang

本月最佳作家

@Lilian Huang

文章

#InterSystems IRIS for Health

如何构建代理人工智能 RAG 应用程序：分步指南

按Lilian Huang

Iris-AgenticAI: 基于OpenAI智能体SDK驱动的企业自动化多智能体工作流平台

按Lilian Huang

Récapitulation de la communauté des développeurs, avril 2025

Résumé de la communauté des développeurs d'InterSystems, Avril 2025

Best Practice for Existing ODBC Connection When System Becomes IRIS for HealthShare

Scenario:

Questions:

Embedded Python query

InterSystems 开发者社区摘要，四月 2025