JC wrote: >The data access class always opens a connection, does the query and >closes >the connection again (thx to you guys, we now have a couple of extra >dispose statements in there as well, made some difference - thx)
I cannot see why this should have made any difference, since Dispose is calling Close, doing nothing extra! (this is based on Reflectors info on SqlConnection v1.1) Correct me, if i am wrong here... >Environment is: COM+ on winXP. SQL 200 on Win 2000. Development in >Vb.NET >using the data.sqlclient classes to connect and do queries. The COM+ >packages are deployed as "library" It is by any chance possible to not use COM+? Lets see if the problem lies within COM+... // Ryan ------------------------------------- The information included in this message is personal and/or confidential and intended exclusively for the addressees as stated. This message and/or the accompanying documents may contain confidential information and should be handled accordingly. If you are not the intended reader of this message, we urgently request that you notify Centric immediately and that you delete this e-mail and any copies of it from your system and destroy any printouts immediately. It is forbidden to distribute, reproduce, use or disclose the information in this e-mail to third parties without obtaining prior permission from Centric. We expressly point out that there are risks associated with the use of e-mail. Centric and the companies within the group shall not accept any liability whatsoever for damage resulting from the use of e-mail. Legally binding obligations can only arise for Centric by means of a written instrument, signed by an authorized representative of Centric. ------------------------------------- =================================== This list is hosted by DevelopMentor� http://www.develop.com NEW! ASP.NET courses you may be interested in: 2 Days of ASP.NET, 29 Sept 2003, in Redmond http://www.develop.com/courses/2daspdotnet Guerrilla ASP.NET, 13 Oct 2003, in Boston http://www.develop.com/courses/gaspdotnet View archives and manage your subscription(s) at http://discuss.develop.com
