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" <h-inoue@dream.email.ne.jp> To: Asif Shaikh <asif.shaikh@in.ibm.com> Cc: pgsql-odbc@postgresql.org 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?
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" <h-inoue@dream.email.ne.jp> Cc: pgsql-odbc@postgresql.org 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) ?