Ok, this is what I’m trying, and I know generally that the variables are correct.
julia> ODBC.drivers()
Dict{String, String} with 2 entries:
"ODBC Drivers" => ""
"ODBC Driver 17 for SQL Server" => "Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.8.so.1.1\0UsageCount=6\0"
julia> ODBC.Connection(Driver={ODBC Driver 17 for SQL Server};Server="server_ip#";Database="DBaseName";UID="User.Name";PWD="passwor")
ERROR: syntax: invalid comprehension syntax
Stacktrace:
[1] top-level scope
@ none:1
So it seems the driver is there, what is “comprehension syntax” ? Should I not be using double quotes ? What about commas vs semicolons? Any working example would be greatly appreciated. Thx.