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

On 04/09/2018 04:52 PM, Adrian Klaver wrote:
> 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?:

Answering my own question after reading the subject line I realize now
you are using:

https://github.com/CartoDB/odbc_fdw

Am not seeing anything wrong at this time.

Did see this issue:

Support PostreSQL 10
https://github.com/CartoDB/odbc_fdw/issues/60

Are you using the latest version of the extension?

>
> 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