# ODBC initialization issues

**URL:** <https://discourse.julialang.org/t/odbc-initialization-issues/3241>\
**Category:** Data\
**Created:** [April 16, 2017, 7:25pm UTC](https://discourse.julialang.org/t/odbc-initialization-issues/3241 "2017-04-16T19:25:34Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![jkbest2](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jkbest2/32/7350_2.png) [@jkbest2](https://discourse.julialang.org/u/jkbest2)\
**Post date:** [April 17, 2017, 6:57pm UTC](https://discourse.julialang.org/t/odbc-initialization-issues/3241/3 "2017-04-17T18:57:49Z")

</div>

When I check `ODBC.API.odbc_dm`, I get

```julia
julia> using ODBC
julia> ODBC.API.odbc_dm
""

```

So it doesn’t seem to be finding anything. When I look in `/usr/lib`, I get

```julia
> cd /usr/lib
> ls *odbc*
libodbccr.so libodbcinst.so libodbc.so psqlodbcw.so
libodbccr.so.2 libodbcinst.so.2 libodbc.so.2
libodbccr.so.2.0.0 libodbcinst.so.2.0.0 libodbc.so.2.0.0

tdbcodbc1.0.4:
libtdbcodbc1.0.4.so pkgIndex.tcl tdbcodbc.tcl

```

So the library is present. After `using ODBC`, I tried to set the library manually, using `libodbc`, `libodbc.so` and `/usr/lib/libodbc.so`. I get a warning about `redefining constant odbc_dm` that I’m not worried about, but if I try `ODBC.listdrivers()` or `ODBC.listdsns()`, I get

```julia
ERROR: UndefVarError: ENV not defined
 in listdrivers() at ~/.julia/v0.5/ODBC/src/ODBC.jl:72
 in eval_user_input(::Any, ::Base.REPL.REPLBackend) at ./REPL.jl:64
 in macro expansion at ./REPL.jl:95 [inlined]
 in (::Base.REPL.##3#4{Base.REPL.REPLBackend})() at ./event.jl:68

```

Do you have any other suggestions? Thanks again.

---

_[View the full topic](https://discourse.julialang.org/t/odbc-initialization-issues/3241)._