Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PGto 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.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?:

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com