Обсуждение: Getting an error for unixODBC library "odbcinst" not found whileexecuting ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10in SuSE Linux 12.0 SP1
Hello, I am trying to install PostgreSQL ODBC drivers in SuSE Linux 12.0 SP1 where I am getting following error: configure: error: unixODBC library "odbcinst" not found I am able to see below libraries though under usr/lib64 libodbcinst.so.2 -> libodbcinst.so.2.0.0 libodbcinst.so.2.0.0 I did set the LD_LIBRARY_PATH to /usr/lib64 and set LDFLAGS=-ldl too. However while executing below command I am getting an error: ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10/data I have tried to change --with-unixodbc multiple times but getting same error. I also had a look into other posts but didn't work for me. Any help will really be appreciated. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html
Jaydip wrote: > I am trying to install PostgreSQL ODBC drivers in SuSE Linux 12.0 SP1 where > I am getting following error: > configure: error: unixODBC library "odbcinst" not found The configure script checks first for the odbc_config tool in the path; apparently, this succeeded. It then checks for the odbcinst library using the default or configured compiler/linker settings. > ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10/data If unixODBC is installed at the default locations, just "--with-unixodbc" without a value should work. Regards, Clemens
I installed ODBC using below command: *zypper install unixODBC.x86_64* where odbcinst library is in /usr/lib64 and odbc_config is there in /usr/bin. The odbcinst.ini and odbc.ini files exists in /etc/unixODBC folder, however both files are of 0 byte size. The output of command: ls -l /usr/lib64/*odbc* lrwxrwxrwx 1 root root 16 Jul 16 16:49 /usr/lib64/libodbc.so.2 -> libodbc.so.2.0.0 -rwxr-xr-x 1 root root 423752 Sep 21 2014 /usr/lib64/libodbc.so.2.0.0 lrwxrwxrwx 1 root root 18 Jul 16 16:49 /usr/lib64/libodbccr.so.2 -> libodbccr.so.2.0.0 -rwxr-xr-x 1 root root 43216 Sep 21 2014 /usr/lib64/libodbccr.so.2.0.0 lrwxrwxrwx 1 root root 20 Jul 16 16:49 /usr/lib64/libodbcinst.so.2 -> libodbcinst.so.2.0.0 -rwxr-xr-x 1 root root 76656 Sep 21 2014 /usr/lib64/libodbcinst.so.2.0.0 I tried --with-unixodbc without any value but still getting same error. I did set LDFLAGS to -ldl as mentioned in one of post but still seeing same error. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html
Jaydip wrote:
> I installed ODBC using below command:
> *zypper install unixODBC.x86_64* where odbcinst library is in /usr/lib64 and
> odbc_config is there in /usr/bin.
>
> I tried --with-unixodbc without any value but still getting same error.
Please try to compile (but not run) the following test program
(with "gcc -o testprogram testprogram.c -l odbcinst"):
--8<--------------------------------------------------------->8--
#include <odbcinst.h>
int main()
{
SQLGetPrivateProfileString("", "", "", "", 0, "");
}
--8<--------------------------------------------------------->8--
If that errors out, the same error should be found somewhere in
configure.log.
Regards,
Clemens
Hi Jaydip, On 2018/07/16 21:11, Jaydip wrote: > I installed ODBC using below command: > *zypper install unixODBC.x86_64* where odbcinst library is in /usr/lib64 and > odbc_config is there in /usr/bin. The odbcinst.ini and odbc.ini files exists > in /etc/unixODBC folder, however both files are of 0 byte size. > > The output of command: ls -l /usr/lib64/*odbc* > > lrwxrwxrwx 1 root root 16 Jul 16 16:49 /usr/lib64/libodbc.so.2 -> > libodbc.so.2.0.0 > -rwxr-xr-x 1 root root 423752 Sep 21 2014 /usr/lib64/libodbc.so.2.0.0 > lrwxrwxrwx 1 root root 18 Jul 16 16:49 /usr/lib64/libodbccr.so.2 -> > libodbccr.so.2.0.0 > -rwxr-xr-x 1 root root 43216 Sep 21 2014 /usr/lib64/libodbccr.so.2.0.0 > lrwxrwxrwx 1 root root 20 Jul 16 16:49 /usr/lib64/libodbcinst.so.2 -> Isn't there libodbcinst.so? regards, Hiroshi Inoue > libodbcinst.so.2.0.0 > -rwxr-xr-x 1 root root 76656 Sep 21 2014 /usr/lib64/libodbcinst.so.2.0.0 > > > I tried --with-unixodbc without any value but still getting same error. I > did set LDFLAGS to -ldl as mentioned in one of post but still seeing same > error. > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html
The issue got resolved after renaming the libodbccr.so.2.0.0 to libodbcinst.so -- Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html