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

2018-04-11 Thread Adrian Klaver
On 04/11/2018 01:20 PM, karthik kumar wrote: Db2 server on a docker container on my laptop: IP address 172.17.0.4 Db2 client where postgres server is installed is on a different container.  IP address: 172.17.0.3 Output of db2 list node directory Node 2 entry:  Node name                   

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

2018-04-11 Thread Adrian Klaver
On 04/11/2018 01:20 PM, karthik kumar wrote: This is the error we see in the ODBC trace log ODBC][586][1523477070.240690][__handles.c][450]         Exit:[SQL_SUCCESS]             Environment = 0x556f874716a0 [ODBC][586][1523477070.240741][SQLSetEnvAttr.c][182]         Entry:             Envi

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

2018-04-11 Thread karthik kumar
>> > I'm not a networking guru, but it sure looks like something is trying to > connect with an IPv6 loopback address. To me, this is the smoking gun. > > > > yes that much we figured it out here. Question is, why is isql able to connect, but not fdw via psql. At the end both isql and fdw should

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

2018-04-11 Thread Steven Hirsch
On Wed, 11 Apr 2018, karthik kumar wrote: This is the error we see in the ODBC trace log         DIAG [08001] [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error

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

2018-04-11 Thread karthik kumar
This is the error we see in the ODBC trace log ODBC][586][1523477070.240690][__handles.c][450] Exit:[SQL_SUCCESS] Environment = 0x556f874716a0 [ODBC][586][1523477070.240741][SQLSetEnvAttr.c][182] Entry: Environment = 0x556f874716a0 Attribute = S

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

2018-04-11 Thread Adrian Klaver
On 04/11/2018 11:22 AM, karthik kumar wrote: Hello Adrian I built fdw with debug option and ran it with debug option.  Here is the output postgres=# select * from odbc_testt; DEBUG:  StartTransactionCommand DEBUG:  StartTransaction DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPR

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

2018-04-11 Thread Steven Hirsch
On Wed, 11 Apr 2018, karthik kumar wrote: Hello Adrian I built fdw with debug option and ran it with debug option.  Here is the output postgres=# select * from odbc_testt; DEBUG:  StartTransactionCommand DEBUG:  StartTransaction DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,

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

2018-04-11 Thread karthik kumar
Hello Adrian I built fdw with debug option and ran it with debug option. Here is the output postgres=# select * from odbc_testt; DEBUG: StartTransactionCommand DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

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

2018-04-09 Thread karthik kumar
On Mon, Apr 9, 2018 at 7: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 > > wrote: >> >> On 04/09/2018 02:10 PM, karthik kumar wrote: >> > > Assuming using this: >> >

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

2018-04-09 Thread Adrian Klaver
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 mailto:adrian.kla...@aklaver.com>> wrote:     On 04/09/2018 02:10 PM, karthik kumar wrote:     Assuming using this:     https://github.com/Zhen

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

2018-04-09 Thread Adrian Klaver
On 04/09/2018 02:37 PM, karthik kumar wrote: On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver > wrote: On 04/09/2018 02:10 PM, karthik kumar wrote: Assuming using this: https://github.com/ZhengYang/odbc_fdw I believe that shou

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

2018-04-09 Thread karthik kumar
On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver wrote: > On 04/09/2018 02:10 PM, karthik kumar wrote: > >> >> >> >> >> On 04/09/2018 01:01 PM, karthik kumar wrote: >> >> Hi Guru's, >> >> I am trying to access few table present in DB2 LUW from postgres >> database. >> All commands wo

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

2018-04-09 Thread Adrian Klaver
On 04/09/2018 02:10 PM, karthik kumar wrote: On 04/09/2018 01:01 PM, karthik kumar wrote: Hi Guru's, I am trying to access few table present in DB2 LUW from postgres database. All commands work fine, however when I try to select data from table it throws error: pg@a