On 04/09/2018 02:10 PM, karthik kumar wrote:
>
>
>
>
> On 04/09/2018 01:01 PM, karthik kumar wrote:
>
> Hi Guru's,
>
> I am trying to access few table present in DB2 LUW from postgres
> database.
> All commands work fine, however when I try to select data from table
> it throws error:
>
> pg@a92a3741d40e:~/odbc_fdw$ psql -d postgres
> psql (10.1)
> Type "help" for help.
>
> postgres=# create extension odbc_fdw;
> CREATE EXTENSION
>
> postgres=# CREATE SERVER odbc_db2 FOREIGN DATA WRAPPER odbc_fdw
> OPTIONS (dsn 'SAMPLE');
> CREATE SERVER
>
>
>
> postgres=# CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS
> (odbc_UID 'db2inst1', odbc_PWD 'db2inst1');
>
>
> Assuming using this:
>
> https://github.com/ZhengYang/odbc_fdw
> <https://github.com/ZhengYang/odbc_fdw>
>
> I believe that should be username and password per above link:
>
> "CREATE USER MAPPING FOR postgres
> SERVER odbc_server
> OPTIONS (username 'root', password '');
> "
>
> Yes.
Does 'yes' mean you changed this:
CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (odbc_UID
'db2inst1', odbc_PWD 'db2inst1');
to this?:
CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (username
'db2inst1', password 'db2inst1');
>
> Thanks,
> Karthik.
>
--
Adrian Klaver
adrian.klaver@aklaver.com