Re: DBlink, postgres to DB2

Hi ,

While i try to install psqlDDBC, i get this error , i have SUSE Linux
Enterprise Server 11 , trying to find a solution still have no idea.

./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking -Wall is a valid compile option... yes
checking for odbc_config... no
configure: error: odbc_config not found (required for unixODBC build)

Regards
Manmohan. K

On Thu, Oct 23, 2014 at 2:41 PM, Миша Тюрин <tmihail(at)bk(dot)ru> wrote:

>
> http://multicorn.org/
> another cool stuff to generalize interconnections
>
>
> Wed, 22 Oct 2014 22:34:06 -0700 от Postgres India <pgbugindia(at)gmail(dot)com>:
>
> Thanks a lot Remi, Merlin and Pavel...........I will give it a try.
>
> On Wed, Oct 22, 2014 at 6:36 AM, Merlin Moncure <mmoncure(at)gmail(dot)com
> <https://e.mail.ru/compose/?mailto=mailto%3ammoncure(at)gmail(dot)com>> wrote:
>
> On Wed, Oct 22, 2014 at 5:56 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com
> <https://e.mail.ru/compose/?mailto=mailto%3apavel(dot)stehule(at)gmail(dot)com>>
> wrote:
> > Hi
> >
> > try to use a Perl implementation https://github.com/davidfetter/DBI-Link
> >
> > There is a DBD driver for DB2
> http://search.cpan.org/dist/DBD-DB2/DB2.pod
> >
> > Or you can use a mentioned fdw wrapper - there is ODBC wrapper
> > https://wiki.postgresql.org/wiki/Foreign_data_wrappers#odbc_fdw and you
> can
> > access DB2 via generic ODBC DB2 driver
>
> jdbc-fdw should work too.
>
> https://github.com/atris/JDBC_FDW
>
> merlin
>
>
>
>
>
>