# Connect Julia with mssql server

**URL:** https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951
**Category:** New to Julia
**Created:** [June 6, 2023, 3:40pm UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951 "2023-06-06T15:40:03Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Jcverni](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jcverni/32/50682_2.png) [@Jcverni](https://discourse.julialang.org/u/Jcverni)
#### Post date: [June 6, 2023, 3:40pm UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/1 "2023-06-06T15:40:03Z")

</div>

Hello people, this is my second question to raise in the forum, the first one was completely resolved and I am very grateful.  
Now…it’s very easy to communicate python or F# with a sqlserver database in Azure, for example, because those languages ​​have many DB connectors, but I can’t do it in Julia! or I can’t find the right paper. Could someone help me or guide me?  
Thank you!!

---

<div class="post-metadata">

### Author: ![mrufsvold](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mrufsvold/32/31600_2.png) [@mrufsvold](https://discourse.julialang.org/u/mrufsvold)
#### Post date: [June 6, 2023, 4:13pm UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/2 "2023-06-06T16:13:42Z")

</div>

Did you look at [MySQL.jl](https://github.com/JuliaDatabases/MySQL.jl) yet?

---

<div class="post-metadata">

### Author: ![Jcverni](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jcverni/32/50682_2.png) [@Jcverni](https://discourse.julialang.org/u/Jcverni)
#### Post date: [June 6, 2023, 6:11pm UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/3 "2023-06-06T18:11:13Z")

</div>

Not yet, but I need to build a database that is in mssql server

---

<div class="post-metadata">

### Author: ![exyi](https://avatars.discourse-cdn.com/v4/letter/e/8baadc/32.png) [@exyi](https://discourse.julialang.org/u/exyi)
#### Post date: [June 10, 2023, 9:20pm UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/4 "2023-06-10T21:20:04Z")

</div>

I think the way is to use Microsoft’s ODBC driver with https://odbc.juliadatabases.org/dev/#ODBC.jl. This StackOverflow post contains some tips on how to get it working [Connection string for SQL Server in Julia ODBC - Stack Overflow](https://stackoverflow.com/a/70967107/3577667), but it might be easier if you are on Windows

(Sidenote: if you are building a new DB from scratch and need to connect to it from a number of different platforms, I’d consider choosing a more mainstream DBMS. For example, PostgreSQL protocol has much better support across programming languages)

---

<div class="post-metadata">

### Author: ![Jcverni](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jcverni/32/50682_2.png) [@Jcverni](https://discourse.julialang.org/u/Jcverni)
#### Post date: [June 11, 2023, 3:44am UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/5 "2023-06-11T03:44:48Z")

</div>

ok, tanks

---

<div class="post-metadata">

### Author: ![Thiago-Simoes](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/thiago-simoes/32/50660_2.png) [@Thiago-Simoes](https://discourse.julialang.org/u/Thiago-Simoes)
#### Post date: [June 12, 2023, 2:15am UTC](https://discourse.julialang.org/t/connect-julia-with-mssql-server/99951/6 "2023-06-12T02:15:38Z")

</div>

> (Sidenote: if you are building a new DB from scratch and need to connect to it from a number of different platforms, I’d consider choosing a more mainstream DBMS. For example, PostgreSQL protocol has much better support across programming languages)

Just to complement, today in the Julia environment I think MySQL is the best choice when it comes to support. The MySQL.jl package is a good standard database interface, but if you prefer options like PostgreSQL, LibPQ.jl will really do too!
