Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2

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(at)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(dot)klaver(at)aklaver(dot)com