ExecuteScalar requires an open and available Connection. The connection's current state is Open, Exe

  • Thread starter Thread starter hasmukh4u
  • Start date Start date
H

hasmukh4u

I am getting this exception not frequently but once in a while and all
database operation gets stopped after this exception. Please suggest
either a prevention or cure.

Exception(03-08-2006 11:58:27):GetSingleCommand: SELECT
permission_config_tbl.permission_value FROM permission_config_tbl
where permission_config_tbl.permission_item_id = (select
showthisevent_perm_id from Event_def_tbl where eventminortype = 5002)
and permission_config_tbl.instance_id = 2 ExecuteScalar requires an
open and available Connection. The connection's current state is Open,
Executing. System.Data at
System.Data.OleDb.OleDbConnection.SetStateExecuting(OleDbCommand
attempt, String method, Boolean flag)
at
System.Data.OleDb.OleDbCommand.ValidateConnectionAndTransaction(String
method, Int32& localState)
at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteScalar()
at SGClient.SGClientHelperLib.cDBWrapper.GetSingleCommand(String
SQLQuery)

What could be the potential cause of this exception?

Thanks in advance :)
 
Back
Top