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

On 04/09/2018 02:37 PM, karthik kumar wrote:
>
>
> On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com