Re: Postgresql and VBA - Connection Timeout

2019-07-13 Thread Wayne Mell
Subject: Re: Postgresql and VBA - Connection Timeout Hi Wayne, On 2019/07/13 0:05, Wayne Mell wrote: Thank you Adrian, The link you sent had an answer that worked. I had to edit the psqlodbc35w.dll file and change SET statement_timeout = %d to SET statement_timeout = 0 . Somewhere in the thread

Re: Postgresql and VBA - Connection Timeout

2019-07-12 Thread Inoue, Hiroshi
o the ODBC list as well. Thanks everyone who replied. Wayne *From:* Adrian Klaver *Sent:* Thursday, July 11, 2019 3:21 PM *To:* Wayne Mell; pgsql-general@lists.postgresql.org *Subject:* Re: Postgresql and VBA - Conne

Re: Postgresql and VBA - Connection Timeout

2019-07-12 Thread Wayne Mell
plied. Wayne From: Adrian Klaver Sent: Thursday, July 11, 2019 3:21 PM To: Wayne Mell; pgsql-general@lists.postgresql.org Subject: Re: Postgresql and VBA - Connection Timeout On 7/11/19 1:04 PM, Wayne Mell wrote: > Can someone help me with executing a postgres

Re: Postgresql and VBA - Connection Timeout

2019-07-11 Thread Adrian Klaver
On 7/11/19 1:04 PM, Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling

Re: Postgresql and VBA - Connection Timeout

2019-07-11 Thread George Weaver
On 11/07/2019 3:04 p.m., Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Canc

Re: Postgresql and VBA - Connection Timeout

2019-07-11 Thread Adrian Klaver
On 7/11/19 1:04 PM, Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling

Postgresql and VBA - Connection Timeout

2019-07-11 Thread Wayne Mell
Can someone help me with executing a postgres function from VBA? No matter what function I call, it always times out after exactly 30 seconds. I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling statement due to statement timeout" in