Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PGto DB2 - Mailing list pgsql-general

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