On May 3, 11:55 am, "John" <J...@nospam.infovis.co.uk> wrote:
> Hi
>
> I have a vb.net app that opens an access database runs several sql action
> queries on the tables and closes the db. This is done every few minutes. The
> problem is that sometimes I get an error 'ExecuteNonQuery requires an open
> and available Connection. The connection's current state is closed'. My
> question is; is there a situation where an app automatically closes the db
> connection causing this error and is there a way to prevent this?
>
> Thanks
>
> Regards

"rowe_newsgroups" <rowe_email@yahoo.com> wrote in message
news:1178210814.449498.96420@l77g2000hsb.googlegroups.com...
> On May 3, 11:55 am, "John" <J...@nospam.infovis.co.uk> wrote:
>> Hi
>>
>> I have a vb.net app that opens an access database runs several sql action
>> queries on the tables and closes the db. This is done every few minutes.
>> The
>> problem is that sometimes I get an error 'ExecuteNonQuery requires an
>> open
>> and available Connection. The connection's current state is closed'. My
>> question is; is there a situation where an app automatically closes the
>> db
>> connection causing this error and is there a way to prevent this?
>>
>> Thanks
>>
>> Regards
>
> I'm guessing you are trying to use a global connection object right?
>
> If so, change the code to open a connection to the database, execute
> your commands, and then close/dispose of the command and connection.
> You should try to avoid using a "global" connection object at all
> costs as it can lead to serious problems (with very few benefits). If
> I guessed wrong, please post your code so I can take a look.
>
> Thanks,
>
> Seth Rowe
>
>

> Is there a way to ensure that all queries get executed or none?
>

> Hi Seth
>
> It is true that I am opening a global connection. Executing only some of
> sql queries will cause problem with the integrity of the data in the
> database. By using a global connection I was hoping to provide a
> guaranteed connection to all queries reducing any expected problems. Is
> there a way to ensure that all queries get executed or none?
>
> Thanks
>
> Regards
>
> "rowe_newsgroups" <rowe_email@yahoo.com> wrote in message
> news:1178210814.449498.96420@l77g2000hsb.googlegroups.com...
>> On May 3, 11:55 am, "John" <J...@nospam.infovis.co.uk> wrote:
>>> Hi
>>>
>>> I have a vb.net app that opens an access database runs several sql
>>> action
>>> queries on the tables and closes the db. This is done every few minutes.
>>> The
>>> problem is that sometimes I get an error 'ExecuteNonQuery requires an
>>> open
>>> and available Connection. The connection's current state is closed'. My
>>> question is; is there a situation where an app automatically closes the
>>> db
>>> connection causing this error and is there a way to prevent this?
>>>
>>> Thanks
>>>
>>> Regards
>>
>> I'm guessing you are trying to use a global connection object right?
>>
>> If so, change the code to open a connection to the database, execute
>> your commands, and then close/dispose of the command and connection.
>> You should try to avoid using a "global" connection object at all
>> costs as it can lead to serious problems (with very few benefits). If
>> I guessed wrong, please post your code so I can take a look.
>>
>> Thanks,
>>
>> Seth Rowe
>>
>>
>
>