Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 tell me reg. opening a common SqlConnection....

Author  Topic 

senthilramtrs
Starting Member

29 Posts

Posted - 2008-05-26 : 05:14:17
hi....

i'm opening & closing SqlConnecion atmost of the the pages...

tell me is it able to declare such common connection in to a common class known as CClass? in app_code...?



Regards,
Senthil Ram TRS

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-05-26 : 05:37:39
connections should be pooled which is the default behaviour to better manage resources.
what is your exact problem?

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

senthilramtrs
Starting Member

29 Posts

Posted - 2008-05-26 : 07:48:21
i think u r telling to use a common connection in "cclass" class...

i think "pooling" means it....

making to refer the same connection for all the deeds....

i think common connection will get affected if threads/more users comes in to ....



Regards,
Senthil Ram TRS
Go to Top of Page
   

- Advertisement -