Re: Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount

Hi Hiroshi Inoue,

Can you please help me understand where can I find Mylog output for my 
test.
I could not go to office today as I am still not quite well. I will check 
with my team member tomorrow about how the old driver worked for him.

Thanks & Regards
Asif G. Shaikh



From:   "Inoue, Hiroshi" <[email protected]>
To:     Asif Shaikh <[email protected]>
Cc:     [email protected]
Date:   08/18/2017 07:54 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon 
redshift, is returning wrong count in SQLRowCount





On 2017/08/18 22:47, Asif Shaikh wrote:
Hi Hiroshi Inoue,

Thanks for the reply and I am sorry for replying late on this.
Actually I was on a sick leave today.

Your statement :-
I see the result * SQLRowCount=2 * here.
--> Yes, this looks to be correct count. In my case, the variable rowc 
doesn't get any value and still holds the initial value which is -1 in 
your test program.

One of my team member informed me that he tried the 8.02.05 driver with 
our application on RHEL and that actually worked whereas the driver 
9.06.04 didn't work on the same setup.
So based on what I understood from his that the driver 9.06.04 is not 
working for him whereas the old driver 8.02.05 works.
Unfortunately, I could not get all the details on this. I will get all the 
details on this on Monday and will get back to you.

Meanwhile, is it possible for you to test your sample program with driver 
9.06.04 to connect to Amazon redshift db and see if that reproduces the 
issue for you too?

Could take Mylog output of your test and send it to me directly?

regards,
Hiroshi Inoue

Thanks & Regards
Asif G. Shaikh



From:        "Inoue, Hiroshi" <[email protected]>
To:        Asif Shaikh <[email protected]>
Cc:        [email protected]
Date:        08/17/2017 06:53 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon 
redshift, is returning wrong count in SQLRowCount





On 2017/08/17 21:30, Asif Shaikh wrote:
I just built your code on 32 bit and used the 32 bit postgre 
driver(8.02.05) but still it gave me same issue. :-(
When you tried, did you connect to Amazon redshift using the postgre 
driver?

I see the result * SQLRowCount=2 * here.
Isn't it an expected result?

Anyway I am testing with my local server
The server's response to the command *select .. into .. from ..* is 
*SELECT 2*.
If the response of Amazon redshift is different, the driver does nothing.

regards,
Hiroshi Inoue




From:        Asif Shaikh/India/IBM
To:        "Inoue, Hiroshi" <[email protected]>
Cc:        [email protected]
Date:        08/17/2017 05:48 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon 
redshift, is returning wrong count in SQLRowCount


Hi Hiroshi Inoue,

I see the same error with the code you sent.
Did you build your application for 64 bit and used  64 bit  postgre 
driver(9.06.04.00) ?

Thanks & Regards
Asif G. Shaikh