Has anyone connected to an external MYSQL database from IRIS?

Question

Question

hi,

I am trying to connect to an external MySQL database from IRIS 2023.1 platform. Does anyone know the right adapter to use? Where do you set up the DSN name?

Thank you in advance.

Sheetal

Product version: IRIS 2023.1

$ZV: HealthShare Unified Care Record 2023.1.0 Build: 1006 Adhoc: 22588 [HealthShare Modules: Health Insight:25.0 + Core:25.0 + Patient Index:25.0] - IRIS for UNIX (Red Hat Enterprise Linux 7 for x86-64) 2022.1.2 (Build 574_0_22407U) Wed Apr 5 2023 11:13:21 EDT

Discussion (5)2

Log in or sign up to continue

Luis Angel Pére... · Feb 22

Hi @Sheetal Kairawala ! Take a look to this article that I wrote:

https://community.intersystems.com/post/connecting-mysql-database-busine...

3 1

score 0 · Answer 1 · 2024-02-26T09:07:49-05:00

Sheetal Kairawala · Feb 26

Thank you Luis

0 0

score 0 · Answer 2 · 2024-02-26T12:17:17-05:00

Luis Angel Pére... · Feb 26

You're welcome!

0 0

score 0 · Answer 3 · 2024-02-27T14:57:06-05:00

Hi Luis,

I was able to install ODBC driver and created a new DSN entry but now I am seeing this error.

Connection failed.
SQLState: (00000) NativeError: [0] Message: [iODBC][Driver Manager]/lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found
Have you seen it before?

score 0 · Answer 4 · 2024-02-27T15:16:59-05:00

Maybe this question from stackoverflow can help you:

https://stackoverflow.com/questions/68231387/starting-vs-code-hangs-with...