Thank you for the reply Igor,
the error just changed into:
*pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib
> 'Apache Ignite' : file not found (0) (SQLDriverConnect)")*
The Ignite Driver seems to be installed. Here's my /etc/odbcinst.ini :
[Apache Ignite]
> Description=Apache Ignite
> Driver=/usr/local/lib/libignite-odbc.so
> Setup=/usr/local/lib/libignite-odbc.so
> DriverODBCVer=03.00
> FileUsage=0
> UsageCount=3
Riccardo Iacomini
*RDSLab*
On Tue, Jun 13, 2017 at 4:31 PM, Igor Sapego <[email protected]> wrote:
> Hi,
>
> Try adding /usr/local/lib/ to LD_LIBRARY_PATH evn variable.
>
> Best Regards,
> Igor
>
> On Tue, Jun 13, 2017 at 4:54 PM, Riccardo Iacomini <
> [email protected]> wrote:
>
>> Hello,
>> I am trying to access Ignite 2.0 using the ODBC driver. I've followed the
>> guide <https://apacheignite.readme.io/docs/odbc-driver>, and tried to
>> access Ignite via Python using the pyodbc module:
>>
>>
>>> *import pyodbc**ignite = pyodbc.connect('DRIVER={Apache
>>> Ignite};ADDRESS=localhost:10800;CACHE=cache1')*
>>
>>
>> however I get:
>>
>> *pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open
>>> lib '/usr/local/lib/libignite-odbc.so' : file not found (0)
>>> (SQLDriverConnect)")*
>>
>>
>> The library is instead located the path; this is the directory listing of
>> */usr/local/lib:*
>>
>> drwxr-xr-x 5 root root 4096 giu 13 15:26 ./
>>> drwxr-xr-x 12 root root 4096 nov 22 2016 ../
>>> lrwxrwxrwx 1 root root 37 giu 13 15:24
>>> libignite-binary-2.0.0.19668.so.0 -> libignite-binary-2.0.0.19668.s
>>> o.0.0.0*
>>> -rwxr-xr-x 1 root root 1777000 giu 13 15:24
>>> libignite-binary-2.0.0.19668.so.0.0.0*
>>> -rw-r--r-- 1 root root 4617182 giu 13 15:24 libignite-binary.a
>>> -rwxr-xr-x 1 root root 1089 giu 13 15:24
>>> libignite-binary.la*
>>> lrwxrwxrwx 1 root root 37 giu 13 15:24
>>> libignite-binary.so -> libignite-binary-2.0.0.19668.so.0.0.0*
>>> lrwxrwxrwx 1 root root 37 giu 13 15:24
>>> libignite-common-2.0.0.19668.so.0 -> libignite-common-2.0.0.19668.s
>>> o.0.0.0*
>>> -rwxr-xr-x 1 root root 648856 giu 13 15:24
>>> libignite-common-2.0.0.19668.so.0.0.0*
>>> -rw-r--r-- 1 root root 1493756 giu 13 15:24 libignite-common.a
>>> -rwxr-xr-x 1 root root 1054 giu 13 15:24
>>> libignite-common.la*
>>> lrwxrwxrwx 1 root root 37 giu 13 15:24
>>> libignite-common.so -> libignite-common-2.0.0.19668.so.0.0.0*
>>> lrwxrwxrwx 1 root root 35 giu 13 15:24
>>> libignite-odbc-2.0.0.19668.so.0 -> libignite-odbc-2.0.0.19668.so.0.0.0*
>>> -rwxr-xr-x 1 root root 6581160 giu 13 15:24
>>> libignite-odbc-2.0.0.19668.so.0.0.0*
>>> -rw-r--r-- 1 root root 18307190 giu 13 15:24 libignite-odbc.a
>>> -rwxr-xr-x 1 root root 1121 giu 13 15:24 libignite-odbc.la*
>>> lrwxrwxrwx 1 root root 35 giu 13 15:24 libignite-odbc.so
>>> -> libignite-odbc-2.0.0.19668.so.0.0.0*
>>> -rw-rw-r-- 1 riccardo riccardo 46518354 feb 20 12:53 libntl.a
>>> -rwxr-xr-x 1 root root 966 giu 13 15:26 libodbccr.la*
>>> lrwxrwxrwx 1 root root 18 giu 13 15:26 libodbccr.so ->
>>> libodbccr.so.2.0.0*
>>> lrwxrwxrwx 1 root root 18 giu 13 15:26 libodbccr.so.2 ->
>>> libodbccr.so.2.0.0*
>>> -rwxr-xr-x 1 root root 507264 giu 13 15:26 libodbccr.so.2.0.0*
>>> -rwxr-xr-x 1 root root 1015 giu 13 15:26 libodbcinst.la*
>>> lrwxrwxrwx 1 root root 20 giu 13 15:26 libodbcinst.so ->
>>> libodbcinst.so.2.0.0*
>>> lrwxrwxrwx 1 root root 20 giu 13 15:26 libodbcinst.so.2
>>> -> libodbcinst.so.2.0.0*
>>> -rwxr-xr-x 1 root root 463392 giu 13 15:26
>>> libodbcinst.so.2.0.0*
>>> -rwxr-xr-x 1 root root 991 giu 13 15:26 libodbc.la*
>>> lrwxrwxrwx 1 root root 16 giu 13 15:26 libodbc.so ->
>>> libodbc.so.2.0.0*
>>> lrwxrwxrwx 1 root root 16 giu 13 15:26 libodbc.so.2 ->
>>> libodbc.so.2.0.0*
>>> -rwxr-xr-x 1 root root 2274544 giu 13 15:26 libodbc.so.2.0.0*
>>> drwxrwsr-x 4 root staff 4096 nov 29 2016 python2.7/
>>> drwxrwsr-x 3 root staff 4096 ott 21 2015 python3.5/
>>> drwxr-xr-x 3 root root 4096 giu 12 23:38 site_ruby/
>>
>>
>> Any suggestion on how to procede?
>>
>> Thank you
>>
>> Riccardo Iacomini
>>
>>
>> *RDSLab*
>>
>
>
