Re: ODBC driver issue

2017-06-15 Thread Igor Sapego
Weird issue. When it comes to ODBC, MSDN has answers to many questions. Also, you may take a look at the following links: http://www.easysoft.com/developer/languages/c/odbc_tutorial.html http://www.easysoft.com/developer/languages/c/odbc-tutorial-fetching-results.html http://www.easysoft.com/deve

Re: ODBC driver issue

2017-06-15 Thread Riccardo Iacomini
The env command confirmed that the variable was correctly set. I tried to go over the installation process again, and now I managed to get it working. I do not actually know the exact reason, but let's say I am happy with it. I've now configured a Cassandra backed cache, and wanted to query it usi

Re: ODBC driver issue

2017-06-15 Thread Igor Sapego
Have you restarted your terminal after that? What does env command show? Is it set? Best Regards, Igor On Wed, Jun 14, 2017 at 6:18 PM, Riccardo Iacomini < riccardo.iacom...@rdslab.com> wrote: > Yes, I've set the env variable, globally in /etc/environment. Just for > completeness, I am running U

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
Yes, I've set the env variable, globally in /etc/environment. Just for completeness, I am running Ubuntu 16.04. Best Riccardo Iacomini *RDSLab* On Wed, Jun 14, 2017 at 1:02 PM, Igor Sapego wrote: > Do you set LD_LIBRARY_PATH to /usr/local/lib? If 'yes' then > can you describe in details how

Re: ODBC driver issue

2017-06-14 Thread Igor Sapego
Do you set LD_LIBRARY_PATH to /usr/local/lib? If 'yes' then can you describe in details how you do that? This may help to identify an issue. Best Regards, Igor On Wed, Jun 14, 2017 at 12:30 PM, Riccardo Iacomini < riccardo.iacom...@rdslab.com> wrote: > Hello Igor, > I double checked the document

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
Hello Igor, I double checked the documentation and went over the steps again to be sure everything is ok. I tried running your command, that's the output: linux-vdso.so.1 => (0x7fff75dd6000) > libignite-binary-2.0.0.19668.so.0 => > /usr/local/lib/libignite-binary-2.0.0.19668.

Re: ODBC driver issue

2017-06-14 Thread Igor Sapego
So, setting LD_LIBRARY_PATH to /usr/local/lib should definetly help. Are you sure your did everything right? Try the following command (in one line): LD_LIBRARY_PATH=/usr/local/lib ldd /usr/local/lib/libignite-odbc.so Best Regards, Igor On Wed, Jun 14, 2017 at 10:15 AM, Riccardo Iacomini < riccar

Re: ODBC driver issue

2017-06-14 Thread Riccardo Iacomini
As asked: > > linux-vdso.so.1 => (0x7ffca6776000) > libignite-binary-2.0.0.19668.so.0 => not found > libodbcinst.so.2 => /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 > (0x7fb92ead4000) > libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 > (0x7fb92e751000) > libc.so.6 => /lib/x8

Re: ODBC driver issue

2017-06-13 Thread Igor Sapego
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 < riccardo.iacom...@rdslab.com> wrote: > Thank you for the reply Igor, > > the error just change

Re: ODBC driver issue

2017-06-13 Thread Riccardo Iacomini
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] > Descripti

Re: ODBC driver issue

2017-06-13 Thread Igor Sapego
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 < riccardo.iacom...@rdslab.com> wrote: > Hello, > I am trying to access Ignite 2.0 using the ODBC driver. I've followed the > guide

ODBC driver issue

2017-06-13 Thread Riccardo Iacomini
Hello, I am trying to access Ignite 2.0 using the ODBC driver. I've followed the guide , and tried to access Ignite via Python using the pyodbc module: > *import pyodbc**ignite = pyodbc.connect('DRIVER={Apache > Ignite};ADDRESS=localhost:10800;CACH