From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Carlos Augusto <caugustofo(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Issue related to command timeout after 30s |
Date: | 2020-05-19 05:02:27 |
Message-ID: | b0bbb769-775e-75d5-45fb-f39ce837a9a8@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Carlos,
On 2020/05/18 23:45, Carlos Augusto wrote:
> Hi Guys,
>
> I'm facing a issue related to command timeout when using psqlodbc.
>
> When i tried to copy data from a remote postgresql database to a sql
> server database, i'm get the following error:
>
> Do you know how to fix this?
>
> Error 0xc0047062: Data Flow Task 1: System.Data.Odbc.OdbcException
> (0x80131937): ERROR [57014] ERROR: cancelling command because of the
> command timeout;
> Error while executing the query
> at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
> RetCode retcode)
Could you please try to set
System.Data.Odbc.OdbcCommand.CommandTimeout=0
?
regards,
Hiroshi Inoue
> at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
> behavior, String method, Boolean needReader, Object[] methodArguments,
> SQL_API odbcApiMethod)
> at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior
> behavior, String method, Boolean needReader)
> at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
> at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior
> behavior)
> at
> System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
> behavior)
> at
> Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute()
> at
> Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100
> wrapper) (SQL Server Import and Export Wizard)
>
> Error 0xc004701a: Data Flow Task 1: Source 1 - alarme_ciclo failed the
> pre-execute phase and returned error code 0x80131937.
> (SQL Server Import and Export Wizard)
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Augusto | 2020-05-19 17:02:31 | Re: Issue related to command timeout after 30s |
Previous Message | Carlos Augusto | 2020-05-18 14:45:22 | Issue related to command timeout after 30s |