ODBC isql error

Hi, I tried testing my odbc build with isql, but I get the following error: [ISQL]ERROR: Could not SQLAllocEnv I tried, dltest /usr/local/lib/libodbchive.so SQLAllocEnv which succeeds, so I guess the entry point should be found. Any suggestions anyone? Amogh

Re: ODBC isql error

Hi Amogh, I found that I need to add to my LD_LIBRARY_PATH so that it knows where to find libodbchive.so. If this environment variable is already set correctly, please provide the location and contents of your odbc.ini file and the output of 'odbcinst -j' and 'odbcinst -q -s -n '. HTH! -Vinithra

ODBC isql error while testing

Hi, i built Hive odbc driver following http://wiki.apache.org/hadoop/Hive/HiveODBC and wanted to test it with isql, but i get the following error: [ISQL]ERROR: Could not SQLAllocEnv I set LD_LIBRARY_PATH so libhiveclient.so can be found correctly. I also tried, dltest libodbchive.so SQLAllocEnv w

Re: ODBC isql error while testing

It looks like isql cannot load libodbchive.so. Please make sure that all three .so files libodbchive.so, libhiveclient.so, and libthrift.so can be found in LD_LIBRARY_PATH. On Sep 4, 2010, at 1:31 PM, Ariel Leiva wrote: > Hi, i built Hive odbc driver following > http://wiki.apache.org/hadoop

Re: ODBC isql error while testing

All three .so files can be found in LD_LIBRARY_PATH and i am still getting the same error. Thanks for your suggestion. On Tue, Sep 7, 2010 at 1:41 AM, Ning Zhang wrote: > It looks like isql cannot load libodbchive.so. Please make sure that all > three .so files libodbchive.so, libhiveclient.so,

Re: ODBC isql error while testing

Something you can check out are: - Did you compiled and deployed your code in different environment (Linux/C compier version)? If so there might incompatibility issues in the kernel/C .so files - Can you check 'ldd isql' and see which .so files it loads? Particularly libodbc.so should be the

Re: ODBC isql error while testing

Hi Ariel, Here are a couple more things to try: 1) Force libhiveodbc.so to be loaded first by setting the LD_PRELOAD environment library: % LD_PRELOAD=/usr/local/unixODBC/lib/libodbchive.so isql -v Hive It turns out that SQLAllocEnv is defined in both libodbchive.so *and* libodbc.so. I have not

Re: ODBC isql error while testing

Thanks Carl, i could test ODBC driver for Hive following what you suggested as 1) Ariel On Wed, Sep 8, 2010 at 4:59 AM, Carl Steinbach wrote: > Hi Ariel, > > Here are a couple more things to try: > > 1) Force libhiveodbc.so to be loaded first by setting the LD_PRELOAD > environment library: > >