From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | onur gulsevgi <ogulsevgi(at)gmail(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Fwd: configure: error: unixODBC library "odbcinst" not found while trying to compile odbc |
Date: | 2013-07-16 11:06:46 |
Message-ID: | CALSLE1Mo5PbVEW28ConAWpvusq+7jWm=DeYEC+B2U-Ztuxd_Yw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On Tue, Jul 16, 2013 at 12:13 AM, onur gulsevgi <ogulsevgi(at)gmail(dot)com> wrote:
> In a project, I was asked to create a database link between Oracle to
> PostGreSQL. I thought that I can use Oracle’s Heterogeneous Services.
> Oracle Database is running on Sparc Server (Solaris 10), so I downloaded
> the free ODBC packages from unixODBC project. They already provide a binary
> package for Solaris but it says it will remove any non pkgmgr content in
> “/usr/local/bin” directory. So I decided to download the source codes and
> build it manually.
>
>
> Here are the commands to build unixODBC:
> ./configure --prefix=/usr/local/unixODBC
> make
> make install
>
>
> Then I try to install psqlodbc-9.02.0100 driver with the following
> command, I get this:
>
> oracle->>./configure --prefix=/data11/ora_bosa/bosadb/odbc/driver
> --without-libpq
> checking for library containing SQLGetPrivateProfileString... no
> configure: error: unixODBC library "odbcinst" not found
> I am doing something wrong. But I could not figure it out. Any help will
> be appreciated.
>
It doesn't know where to find "odbcinst"?
As per your installation "odbc_config --libs"should return you
"-L/usr/local/unixODBC/lib -lodbc"
You should try providing unixodbc location (one where you have installed)
as follows.
./configure --prefix=/data11/ora_bosa/bosadb/odbc/driver --without-libpq *
--with-unixodbc=/usr/local/unixODBC*
Check config.log for additional log messages?
In case there are messages like
libodbc.so: undefined reference to `dlsym'
libodbc.so: undefined reference to `dlerror'
libodbc.so: undefined reference to `dlopen'
libodbc.so: undefined reference to `dlclose'
Then you might be required to add in a link to the "dl" library. Something
like this "-ldl".
export LDFLAGS=-ldl
And then again run configure.
./configure --prefix=/data11/ora_bosa/bosadb/odbc/driver --without-libpq *
--with-unixodbc=/usr/local/unixODBC*
Regards...
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2013-07-18 12:46:48 | getting rid of SnapshotNow |
Previous Message | Tom Lane | 2013-07-16 05:41:23 | Re: Fwd: configure: error: unixODBC library "odbcinst" not found while trying to compile odbc |