Re: DBlink, postgres to DB2

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

2014-10-30 8:47 GMT+01:00 Postgres India <pgbugindia@xxxxxxxxx>:

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)

you are missing a ODBC packages

http://www.unixodbc.org/
http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html

Regards

Pavel

 

Regards

Manmohan. K

On Thu, Oct 23, 2014 at 2:41 PM, Миша Тюрин <tmihail@xxxxx> wrote:

http://multicorn.org/
another cool stuff to generalize interconnections


Wed, 22 Oct 2014 22:34:06 -0700 от Postgres India <pgbugindia@xxxxxxxxx>:

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@xxxxxxxxx> wrote:

On Wed, Oct 22, 2014 at 5:56 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> 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