On 2017/08/21 17:21, Asif Shaikh wrote: 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.
If you can edit connection strings, please add *;debug=1* to the connection string. On Windows You can find mylog_xxxxxx.log under root directory after execution.
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.
