# Using ODBC error on 1.0

**URL:** https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157
**Category:** General Usage
**Tags:** question
**Created:** [August 10, 2018, 8:39am UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157 "2018-08-10T08:39:45Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![jonjilla](https://avatars.discourse-cdn.com/v4/letter/j/7ba0ec/32.png) [@jonjilla](https://discourse.julialang.org/u/jonjilla)
#### Post date: [August 10, 2018, 8:39am UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/1 "2018-08-10T08:39:45Z")

</div>

This was working in Julia 0.6, but doesn’t seem to work anymore. Can someone help me figure out if there is something I’m doing wrong?

julia\> using ODBC  
[Info: Precompiling ODBC [be6f12e9-ca4f-5eb2-a339-a4f995cc0291]  
ERROR: LoadError: LoadError: LoadError: UndefVarError: Libdl not defined

---

<div class="post-metadata">

### Author: ![quinnj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/quinnj/32/11_2.png) [@quinnj](https://discourse.julialang.org/u/quinnj)
#### Post date: [August 10, 2018, 8:46am UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/2 "2018-08-10T08:46:49Z")

</div>

ODBC.jl hasn’t been updated to be compatible with 1.0 yet (since 1.0 was released literally 36 hours ago). If you need to use ODBC.jl, it’s advisable to use 0.6 or perhaps 0.7 at the moment. It should be updated soon and you can watch the repository [here](https://github.com/JuliaDatabases/ODBC.jl) for when the next release happens.

---

<div class="post-metadata">

### Author: ![jonjilla](https://avatars.discourse-cdn.com/v4/letter/j/7ba0ec/32.png) [@jonjilla](https://discourse.julialang.org/u/jonjilla)
#### Post date: [August 10, 2018, 8:52am UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/3 "2018-08-10T08:52:04Z")

</div>

Thanks for the info. I wasn’t sure, since I was able to add the ODBC package successfully in 1.0. OK, I’ll wait a bit longer.

---

<div class="post-metadata">

### Author: ![jonjilla](https://avatars.discourse-cdn.com/v4/letter/j/7ba0ec/32.png) [@jonjilla](https://discourse.julialang.org/u/jonjilla)
#### Post date: [August 16, 2018, 6:39pm UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/4 "2018-08-16T18:39:51Z")

</div>

I’m still seeing this old bug in ODBC re-occur on 0.7 which appears to be fixed. ([https://github.com/JuliaDatabases/ODBC.jl/issues/178](https://github.com/JuliaDatabases/ODBC.jl/issues/178))

I have the workaround which is to modify the DataStreams package for this line:

```
!ismissing(rows) && rows < 0 && throw("Invalid # of rows for Data.Schema

```

But any idea why this is still erroring out in 0.7?

---

<div class="post-metadata">

### Author: ![quinnj](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/quinnj/32/11_2.png) [@quinnj](https://discourse.julialang.org/u/quinnj)
#### Post date: [August 19, 2018, 3:27pm UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/5 "2018-08-19T15:27:39Z")

</div>

ODBC.jl has now been tagged w/ a 1.0-compatible release. Please report any issues you see [here](https://github.com/JuliaDatabases/ODBC.jl/issues).

---

<div class="post-metadata">

### Author: ![jonjilla](https://avatars.discourse-cdn.com/v4/letter/j/7ba0ec/32.png) [@jonjilla](https://discourse.julialang.org/u/jonjilla)
#### Post date: [August 19, 2018, 5:02pm UTC](https://discourse.julialang.org/t/using-odbc-error-on-1-0/13157/6 "2018-08-19T17:02:22Z")

</div>

Thanks, working well now.
