# Initialization Error: ODBC

**URL:** <https://discourse.julialang.org/t/initialization-error-odbc/5884>\
**Category:** Data\
**Created:** [September 14, 2017, 11:14am UTC](https://discourse.julialang.org/t/initialization-error-odbc/5884 "2017-09-14T11:14:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasoriya](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jasoriya/32/1884_2.png) [@jasoriya](https://discourse.julialang.org/u/jasoriya)\
**Post date:** [September 14, 2017, 11:14am UTC](https://discourse.julialang.org/t/initialization-error-odbc/5884/1 "2017-09-14T11:14:51Z")

</div>

I am working with Julia 0.5.2 and I added ODBC package `Pkg.add ("ODBC")`  
On running

> Using ODBC

I get the following error:

> LoadError: InitError: ccall: could not find function SQLAllocHandle in library  
> during initialization of module ODBC  
> while loading /home/shreyansj/.julia/v0.5/ODBC/src/ODBC.jl, in expression starting on line 176  
> in require at base/loading.jl:415  
> in eval at base/boot.jl:234  
> in include\_from\_node1 at base/loading.jl:488  
> in **init** at ODBC/src/ODBC.jl:171  
> in ODBCAllocHandle at ODBC/src/Source.jl:4  
> in SQLAllocHandle at ODBC/src/API.jl:63

I have referred [this](https://discourse.julialang.org/t/odbc-initialization-issues/3241/3) thread and tried the steps there. In /usr/lib none of the below libraries are present:

> lib\_choices = [“libodbc”, “libodbc.so”, “libodbc.so.1”, “libodbc.so.2”, “libodbc.so.3”]

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![avik](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/avik/32/17_2.png) [@avik](https://discourse.julialang.org/u/avik)\
**Post date:** [September 14, 2017, 12:25pm UTC](https://discourse.julialang.org/t/initialization-error-odbc/5884/2 "2017-09-14T12:25:48Z")

</div>

If you’re doing this in linux, you’ll have to install the linux ODBC package (unixodbc or iodbc), and the driver for the database you are connecting to (use google \<database\_name odbc driver\>)