Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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');


If i try to use username it throws error as invalid option

postgres=# CREATE SERVER driver_db5 FOREIGN DATA WRAPPER odbc_fdw OPTIONS (dsn 'sample');
CREATE SERVER

postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS (username  'db2inst1', password 'db2inst1');
ERROR:  invalid option "username"
HINT:  Valid options in this context are: <none>

postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS (odbc_UID  'db2inst1', odbc_PWD 'db2inst1');
CREATE USER MAPPING 


Thanks,
Karthik.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux