Julia, ODBC connection to a remote MS SQL Server

General Usage
,
1

I have been using R to connect to a remote MS SQL Server database, from Ubuntu Linux 21.10 and it works quite well. I’d like to do the same thing from Julia but can not make the connection using the ODBC package. Does anyone have a script that does make a “con”, and would share it with me? I have the “R” equivalent of what I’m trying to achieve. Thx. J.

con <- dbConnect(odbc::odbc(),
                 Driver="ODBC Driver 17 for SQL Server",
                 Server="ip_number",
                 UID="User.Name",
                 PWD=decrypt_gk_pw("key1 word1 key2 word2"),
                 Database="DBName")