Has anyone connected to an external MYSQL database from IRIS?
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
Comments
Hi @Sheetal Kairawala ! Take a look to this article that I wrote:
https://community.intersystems.com/post/connecting-mysql-database-busin…
Thank you Luis
You're welcome!
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?
Maybe this question from stackoverflow can help you:
https://stackoverflow.com/questions/68231387/starting-vs-code-hangs-wit…