B
BD
I am developing C# win form app to work with remote database on SQL
Server 2005. Problem scenario is as follows:
1. a form is open that has downloaded dataset to local cache
2. computer is put into stand-by or hibernation
3. later, computer is brought out of stand-by or hibernation
4. when trying to save or close form, SQL exception comes up
(remote system closed conn)
I know this relates to connection pooling, but I am having a problem
trying to solve it. I am letting VS 2005 do the majority of the code
writing for me so therefore unsure about where to insert code fix.
For example, would I put the code into the "update" statements? I
have seen some articles about coding multiple connections, however,
the articles reference older versions and I am new to C#. At this
time, I am letting VS code the conn string with the wizard.
Thanks for any help,
BD
Server 2005. Problem scenario is as follows:
1. a form is open that has downloaded dataset to local cache
2. computer is put into stand-by or hibernation
3. later, computer is brought out of stand-by or hibernation
4. when trying to save or close form, SQL exception comes up
(remote system closed conn)
I know this relates to connection pooling, but I am having a problem
trying to solve it. I am letting VS 2005 do the majority of the code
writing for me so therefore unsure about where to insert code fix.
For example, would I put the code into the "update" statements? I
have seen some articles about coding multiple connections, however,
the articles reference older versions and I am new to C#. At this
time, I am letting VS code the conn string with the wizard.
Thanks for any help,
BD