|
Replies:
1
-
Pages:
1
-
Last Post:
Jul 3, 2010 2:40 AM
by: mijnjahoegroepsid
|
Threads:
[
Previous
|
Next
]
|
|
|
|
|
|
error when connection timed out
Posted:
Jun 1, 2010 7:37 AM
|
|
|
I have toad open all day. After a while it loses connection.
Now, when fir instance I do: disconnect, I get:
System.InvalidOperationException
Connection must be opened.
Stack Trace:
at Devart.Data.MySql.MySqlConnection.r()
at Devart.Data.MySql.MySqlConnection.Rollback()
at Quest.Toad.MySQL.MySQLConnection.RollbackTransaction(IDbConnection connection, Object transaction, Boolean explicitOrigin)
at Quest.Toad.Db.Connection.CommitRollback(Boolean commit)
- BTW: what will be the quickest way to get a connection back. Mostly I kill TOAD and restart. Reconnect within TOAD takes a long time.
Or is there a way to keep the connection alive?
|
|
|
|
|
|
|
Re: error when connection timed out
Posted:
Jul 3, 2010 2:40 AM
in response to: mijnjahoegroepsid
|
|
|
A bit quiet here lately 
No answer to my own question, just an addition.
The situation is that I browse through some tables on my local db. Every move gets me:
System.InvalidOperationException
Connection must be opened.
Stack Trace:
at Devart.Common.Utils.CheckConnectionOpen(IDbConnection connection)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Quest.Toad.Db.ToadDataAdapter.InternalFill(FastTable table)
at Quest.Toad.Db.ToadDataAdapter.Fill(IFastTable table)
at Quest.Toad.Trl.BaseSqlTrl.ExecuteQuery()
at Quest.Toad.Trl.BaseSqlTrl.Execute()
at Quest.Toad.Trl.BaseSqlTrl.CreateData(ILiveCache entry, IFilterLiveCache filter, FilterInfo filterInfo)
at Quest.Toad.Trl.BaseSqlTrl.GetData(Boolean filtered, FilterInfo filterInfo)
at Quest.Toad.Trl.ShowListTrl.GetTrls()
at Quest.Toad.MySQL.Trl.TableTrl.GetColumnTrls()
at Quest.Toad.Dov.TableDataViewControl.UpdateColumns()
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
