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

On 04/09/2018 02:37 PM, karthik kumar wrote:

On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

    On 04/09/2018 02:10 PM, karthik kumar wrote:

        Assuming using this:

        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>

You are using the extension from below, correct?:

https://github.com/ZhengYang/odbc_fdw

In psql what does the below show?:

\dx

What happens if you do not include the OPTIONS?

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@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com