Thread: odbc_fdw

odbc_fdw

From
Date:
Hi there!

I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware under Win7).
I followed the steps in this guide:
www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source

It seems to work (I can run the server and connect to it with PgAdmin).

Now I'd like to integrate the ODBC_FDW extension in my installation. However, I don't really
understand the steps described on the download page:
pgxn.org/dist/odbc_fdw/0.1.0

Can anybody tell me how to build it? I'm a software developer myself but a Linux newbie...

Thank you for your help!

Re: odbc_fdw

From
"Albe Laurenz"
Date:
fschwend at hsr.ch wrote:
> I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a
VMware under Win7).
> I followed the steps in this guide:
>
www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from
-source
>
> It seems to work (I can run the server and connect to it with
PgAdmin).
>
> Now I'd like to integrate the ODBC_FDW extension in my installation.
However, I don't really
> understand the steps described on the download page:
> pgxn.org/dist/odbc_fdw/0.1.0
>
> Can anybody tell me how to build it? I'm a software developer myself
but a Linux newbie...

I haven't tried it, but looking at the instructions I would say:

1) Install UnixODBC. If you use Packages, make sure you install the
headers too
   (on my RHEL system, the packages are called unixODBC and
unixODBC-devel).

2) Get odbc_fdw and unzip the source.

3) Change into the source directory.

4) Run "make" and "make install" as the web page describes it
(substituting
   the path to your configured PostgreSQL source tree).

If there still is something unclear, ask for details.

Yours,
Laurenz Albe

Re: odbc_fdw

From
"Albe Laurenz"
Date:
Florian Schwendener wrote:
> Thank you for your help. As I know little about Linux and only a bit
> about make files, I really don't know if
> I'm doing the right thing. I've typed this:
>
> root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 make
> make: *** No rule to make target `make'.  Stop.
>
> You see, I haven't come far... Am I doing something wrong?

Yes, there are two "make"s in your line. Try

PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1

Yours,
Laurenz Albe

Re: odbc_fdw

From
"Albe Laurenz"
Date:
Florian Schwendener wrote:
[has problems building odbc_fdw]
> Oh, didn't see that! Now it says:
>
> root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
> make: Nothing to be done for `all'.
>
> I remember trying a few options with the make command. Is it maybe
> already built?

Looks like it.

You can
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 clean
to delete already built files.

Then you can rebuild.

After building, use
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 install
to install.

Yours,
Laurenz Albe

Re: odbc_fdw

From
Eduardo Morras
Date:
At 16:27 28/11/2011, you wrote:
>Hi there!
>
>I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in
>a VMware under Win7).
>I followed the steps in this guide:
>www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source
>
>It seems to work (I can run the server and connect to it with PgAdmin).
>
>Now I'd like to integrate the ODBC_FDW extension in my installation.
>However, I don't really
>understand the steps described on the download page:
>pgxn.org/dist/odbc_fdw/0.1.0
>
>Can anybody tell me how to build it? I'm a software developer myself
>but a Linux newbie...
>
>Thank you for your help!

As a final note, be careful to install only one odbc driver. Some
linux distros use iODBC and others use unixODBC but some apps install
the one they use so you can get a fail system with both libraries
"punching for being the king".

Re: odbc_fdw

From
Eduardo Morras
Date:
At 16:27 28/11/2011, you wrote:
>Hi there!
>
>I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in
>a VMware under Win7).
>I followed the steps in this guide:
>www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source
>
>It seems to work (I can run the server and connect to it with PgAdmin).
>
>Now I'd like to integrate the ODBC_FDW extension in my installation.
>However, I don't really
>understand the steps described on the download page:
>pgxn.org/dist/odbc_fdw/0.1.0
>
>Can anybody tell me how to build it? I'm a software developer myself
>but a Linux newbie...
>
>Thank you for your help!

As a final note, be careful to install only one odbc driver. Some
linux distros use iODBC and others use unixODBC but some apps install
the one they use so you can get a fail system with both libraries
"punching for being the king".



Re: odbc_fdw

From
Florian Schwendener
Date:
Oh, didn't see that! Now it says:

root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
make: Nothing to be done for `all'.

I remember trying a few options with the make command. Is it maybe
already built?

Am 30.11.2011 09:46, schrieb Albe Laurenz:
> Florian Schwendener wrote:
>> Thank you for your help. As I know little about Linux and only a bit
>> about make files, I really don't know if
>> I'm doing the right thing. I've typed this:
>>
>> root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
>> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 make
>> make: *** No rule to make target `make'.  Stop.
>>
>> You see, I haven't come far... Am I doing something wrong?
> Yes, there are two "make"s in your line. Try
>
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
>
> Yours,
> Laurenz Albe


Re: odbc_fdw

From
Florian Schwendener
Date:
Hi Laurenz

Thank you for your help. As I know little about Linux and only a bit
about make files, I really don't know if
I'm doing the right thing. I've typed this:

root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 make
make: *** No rule to make target `make'.  Stop.

You see, I haven't come far... Am I doing something wrong?

Thanks again!
Flo

Am 29.11.2011 10:34, schrieb Albe Laurenz:
> fschwend at hsr.ch wrote:
>> I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a
> VMware under Win7).
>> I followed the steps in this guide:
>>
> www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from
> -source
>> It seems to work (I can run the server and connect to it with
> PgAdmin).
>> Now I'd like to integrate the ODBC_FDW extension in my installation.
> However, I don't really
>> understand the steps described on the download page:
>> pgxn.org/dist/odbc_fdw/0.1.0
>>
>> Can anybody tell me how to build it? I'm a software developer myself
> but a Linux newbie...
>
> I haven't tried it, but looking at the instructions I would say:
>
> 1) Install UnixODBC. If you use Packages, make sure you install the
> headers too
>     (on my RHEL system, the packages are called unixODBC and
> unixODBC-devel).
>
> 2) Get odbc_fdw and unzip the source.
>
> 3) Change into the source directory.
>
> 4) Run "make" and "make install" as the web page describes it
> (substituting
>     the path to your configured PostgreSQL source tree).
>
> If there still is something unclear, ask for details.
>
> Yours,
> Laurenz Albe


Re: odbc_fdw

From
Date:
Thank you! That did it!

I was able to execute the CREATE EXTENSION command. I hope it will work from this point on, otherwise I know where to
findhelp:) 

Thanks again.
Florian

Am 30.11.2011 um 12:01 schrieb "Albe Laurenz" <laurenz.albe@wien.gv.at>:

> Florian Schwendener wrote:
> [has problems building odbc_fdw]
>> Oh, didn't see that! Now it says:
>>
>> root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
>> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
>> make: Nothing to be done for `all'.
>>
>> I remember trying a few options with the make command. Is it maybe
>> already built?
>
> Looks like it.
>
> You can
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 clean
> to delete already built files.
>
> Then you can rebuild.
>
> After building, use
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 install
> to install.
>
> Yours,
> Laurenz Albe

Re: odbc_fdw

From
"Albe Laurenz"
Date:
Florian Schwendener wrote:
> I'm stuck again, now with the extension itself. I've tried like
> everything I could think of filling the fields in
> the example on [1]. My database is named "testdb", my table
"testtable"
> and the (default) schema is
> (I believe) "dbo". Does anybody know the values I need to enter in the
> CREATE FOREIGN TABLE command?
>
> The odbc-connection (named "odbc-test") works fine. The database
server
> is a Microsoft SQL Server 2008 R2.

The comment "I believe" seems to suggest that you are not sure -
maybe you can ask somebody who knows SQL Server for:

- DSN: The name of your ODBC data source
- Name of Database, schema and table.

> Sadly, if the extension can't execute the query, it just says "Opps".
> This isn't very helpful. Should I contact the
> author directly?

Can you quote the exact message?
If it is not helpful at all, yes, contacting the author is probably
the right thing to do.
There is also
https://github.com/ZhengYang/odbc_fdw/issues/
where you can report problems.

> References:
> [1] https://github.com/ZhengYang/odbc_fdw

Yours,
Laurenz Albe

Re: odbc_fdw

From
Florian Schwendener
Date:
Hi again!

I'm stuck again, now with the extension itself. I've tried like
everything I could think of filling the fields in
the example on [1]. My database is named "testdb", my table "testtable"
and the (default) schema is
(I believe) "dbo". Does anybody know the values I need to enter in the
CREATE FOREIGN TABLE command?

The odbc-connection (named "odbc-test") works fine. The database server
is a Microsoft SQL Server 2008 R2.

Sadly, if the extension can't execute the query, it just says "Opps".
This isn't very helpful. Should I contact the
author directly?

Thanks again for your help.
Flo

References:
[1] https://github.com/ZhengYang/odbc_fdw

Am 30.11.2011 12:01, schrieb Albe Laurenz:
> Florian Schwendener wrote:
> [has problems building odbc_fdw]
>> Oh, didn't see that! Now it says:
>>
>> root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
>> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
>> make: Nothing to be done for `all'.
>>
>> I remember trying a few options with the make command. Is it maybe
>> already built?
> Looks like it.
>
> You can
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 clean
> to delete already built files.
>
> Then you can rebuild.
>
> After building, use
> PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 install
> to install.
>
> Yours,
> Laurenz Albe