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

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