Re: DBlink, postgres to DB2

2014-10-30 8:47 GMT+01:00 Postgres India <pgbugindia(at)gmail(dot)com>:

> 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(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
>>
>>
>>
>>
>>
>>
>