471,119 Members | 1,483 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,119 software developers and data experts.

problem with SQL server 2000 connection in C#.net

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?
Nov 15 '05 #1
2 2132
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?

Nov 15 '05 #2
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
Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Refky Wahib | last post: by
17 posts views Thread by Danieltbt05 | last post: by
1 post views Thread by Vikram S | last post: by
8 posts views Thread by Chizl | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.