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

microsoft.public.dotnet.framework.adonet

2 Feb 2007 2:30 PM

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 :)