Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PGto 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@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