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