Hello All,
I need to setup connection between Vertica and SQL server.
Trying to use ODBC loader package
When trying to compile, I am getting this error
make installmkdir -p build
g++ -I /opt/vertica/sdk/include -I /opt/vertica/sdk/examples/HelperLibraries -fPIC -shared -Wall -g -o build/ODBCLoader.so /opt/vertica/sdk/include/Vertica.cpp ODBCLoader.cpp -lodbc
/opt/vertica/bin/vsql -f ddl/install.sql
vsql:ddl/install.sql:2: ROLLBACK 3399: Failure in UDx RPC call InvokeSetExecContext(): Error calling setupExecContext() in User Defined Object [] at [/scratch_a/release/vbuild/vertica/OSS/UDxFence/vertica-udx-C++.cpp:180], error code: 0, message: Error happened in dlopen(): [libodbc.so.2: cannot open shared object file: No such file or directory]
vsql:ddl/install.sql:3: ROLLBACK 3861: Library not found: ODBCLoaderLib
vsql:ddl/install.sql:4: ROLLBACK 3861: Library not found: ODBCLoaderLib
Why is it looking for libodbc.so ? and if its looking where is it looking?
Also attaching the this info
ldd ODBCLoader.so
linux-vdso.so.1 => (0x00007fff2d1fd000)
libodbc.so.2 => not found
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002b981bb04000)
libm.so.6 => /lib64/libm.so.6 (0x00002b981be04000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b981c087000)
libc.so.6 => /lib64/libc.so.6 (0x00002b981c296000)
/lib64/ld-linux-x86-64.so.2 (0x00002b981b685000)