# Julia, ODBC connection to a remote MS SQL Server

**URL:** https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374
**Category:** General Usage
**Tags:** sql, remote
**Created:** [January 28, 2022, 3:00pm UTC](https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374 "2022-01-28T15:00:16Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![jamaas](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jamaas/32/30689_2.png) [@jamaas](https://discourse.julialang.org/u/jamaas)
#### Post date: [January 29, 2022, 4:56pm UTC](https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374/2 "2022-01-29T16:56:50Z")

</div>

Ok, this is what I’m trying, and I know generally that the variables are correct.

```julia
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.

---

_[View the full topic](https://discourse.julialang.org/t/julia-odbc-connection-to-a-remote-ms-sql-server/75374)._