User bio
404 bio not found
Member since Aug 9, 2021
Posts:
Gregor has not published any posts yet.
Replies:

Hi, 

I am struggling with same/similar issue. I tried your code but it does not work or i do not execute it correclty. The latter of which is rather likely. 

My setup:

I have an Instance of InterSystems on a Ubuntu 20.04 VM

On the same VM i am running a MySQL DB and a PostgresQL DB.

I would like to connect first to MySQL and installed the necessary ODBC drivers. 

I tried to configure via this: System Administration > Configuration > Connectivity > SQL Gateway

But here can not specify the DSN name of the MySQL DB. but it asks me to specify a DSN name "that you previously created" but nowhere i can see how to create such a DSN name. In my odbc.ini on the ubuntu VM i have specified the DSN name, user, password, etc. so the MySQL database can receive a connection via ODBC. In this "wizard" i cannot specify these variables. 

Second, i tried your code block and changed the values DSN, user, pw and execute statement. But when I run this code under Systen -> SQL it returns an error (its in german but goes liek this: 
 

"An extrinsic function call must have the form $$tag^rou(..." 

Its daunting.. Please advise. 

Thanks in advance

Certifications & Credly badges:
Gregor has no Certifications & Credly badges yet.
Global Masters badges:
Gregor has no Global Masters badges yet.
Followers:
Gregor has no followers yet.
Following:
Gregor has not followed anybody yet.