problem with SQL server 2000 connection in C#.net

[Ananta]

Hi

I am having a problem with the SQL server connected in VC#.net

I am using the SQLDataAdaptors to access and fill the data to the
DataSets.

There are certain pages in sequence which run one after the another as
a process based on the user interaction. All the pages (even pages
before entering this process) have the data connection to the SQL
server 2000. On some of the specific pages the data connection is
close. If catch the error and open the connection the catch block i
am able to open the connection there. So, does not seem like to be a
problem with the pooling.

I am not sure where the problem is.

Can anyone help?

[Glen Jones MCSD]

Ananta,

I noticed a little note in the MSDN documentation a few days ago. I've read
the SqlCommand Class overview serveral time but I never noticed it before.
Anyway, here is the note:

"If a SqlException is generated by the method executing a SqlCommand, the
SqlConnection remains open when the severity level is 19 or less. When the
severity level is 20 or greater, the server usually closes the
SqlConnection. However, the user can reopen the connection and continue."

This may be whats happing. Hope this helps.

--
Glen Jones MCSD

"Ananta" <an************@thedetail.info> wrote in message
news:d5*************************@posting.google.co m...

Hi

I am having a problem with the SQL server connected in VC#.net

I am using the SQLDataAdaptors to access and fill the data to the
DataSets.

There are certain pages in sequence which run one after the another as
a process based on the user interaction. All the pages (even pages
before entering this process) have the data connection to the SQL
server 2000. On some of the specific pages the data connection is
close. If catch the error and open the connection the catch block i
am able to open the connection there. So, does not seem like to be a
problem with the pooling.

I am not sure where the problem is.

Can anyone help?

[Miha Markic]

Hi Ananta,

"Ananta" <an************@thedetail.info> wrote in message
news:d5*************************@posting.google.co m...

Hi

I am having a problem with the SQL server connected in VC#.net

I am using the SQLDataAdaptors to access and fill the data to the
DataSets.

There are certain pages in sequence which run one after the another as
a process based on the user interaction. All the pages (even pages
before entering this process) have the data connection to the SQL
server 2000. On some of the specific pages the data connection is
close. If catch the error and open the connection the catch block i
am able to open the connection there. So, does not seem like to be a
problem with the pooling.

I am not sure where the problem is.

What are pages? What does it mean that conneciton is closed?
Can you provide some code?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com