A connection attempt failed because the connected party did

A connection attempt failed because the connected party did

Postby 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
providerName="Devart.Data.Oracle" />
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1852
Joined: Wed 02 Nov 2011 09:44

Postby degas » Mon 05 Dec 2011 12:35

Setting the commandTimeOut=0 worked fine.
Thanks a lot
degas
 
Posts: 77
Joined: Mon 16 Feb 2009 18:36
Location: Argentina


Return to dotConnect for Oracle