A connection attempt failed because the connected party did

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
degas
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

A connection attempt failed because the connected party did

Post by degas » Tue 29 Nov 2011 15:01

Message : Network error:: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Stack Trace : at Devart.Data.Oracle.bt.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.bt.a(Byte& A_0)
at xc.l.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at xc.l.b()
at Devart.Data.Oracle.bj.c()
at Devart.Data.Oracle.s.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Devart.Common.DbScript.ExecuteSqlStatement(SqlStatement sqlStatement)
at Devart.Data.Oracle.OracleScript.ExecuteSqlStatement(SqlStatement stmt)
at Devart.Common.DbScript.b(SqlStatement A_0)
at Devart.Common.SqlStatement.Execute()
at Devart.Common.DbScript.ExecuteNext(IDataReader& reader)
at Devart.Common.DbScript.Execute()
at SziCom.SvnDB.OracleDatabase.ApplyGrantsBetweenUsers()
at SziCom.SvnDB.Command.SvnDBMigrateCommand.MigrateDatabaseIncrementally(Int64 RevisionFrom, Int64 RevisionTo)
at SziCom.SvnDB.Command.SvnDBMigrateCommand.Execute(Arguments ConsoleArguments)
at SziCom.SvnDB.Command.SvnDB.TriggerCommand(Arguments args)
at SziCom.SvnDB.Program.Main(String[] Arguments)

I am getting the following error, but the weird thing is that it happens on some machines only (always the sameones)

Here is the connection string

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Wed 30 Nov 2011 10:23

According to your connection string, you use direct mode to connect to database. If your port is not 1521, than you have to set the Port parameter in your connection string.

OracleScript.CommandTimeout = 30 by default. Try using OracleScript.CommandTimeout = 0 and notify us about results. Looking forward to your reply.

degas
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Post by degas » Mon 05 Dec 2011 12:35

Setting the commandTimeOut=0 worked fine.
Thanks a lot

Post Reply