From: | Carlos Augusto <caugustofo(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Issue related to command timeout after 30s |
Date: | 2020-05-18 14:45:22 |
Message-ID: | CAOZyD7WiZmNKnxfOyOO=Wy_MqOonYm4j67SK1dqpW+s4ANxybA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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)
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 | Inoue, Hiroshi | 2020-05-19 05:02:27 | Re: Issue related to command timeout after 30s |
Previous Message | Clemens Ladisch | 2020-05-13 15:04:33 | Re: newer (11+) psqlODBC install on old system |