Well, try running the following command: ldd /usr/local/lib/libignite-odbc.so
This may help us see which library can't be found. Best Regards, Igor On Tue, Jun 13, 2017 at 6:10 PM, Riccardo Iacomini < [email protected]> wrote: > 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* >>> >> >> >
