COM+ and SQL Server 2K App Optimization

[Guest_imported]

I'm developing a client-side application that uses ADO to access a SQL Server 2000 database in a large network (lots of computers would have this app). I read that using MTS could speed up the average data access time, because MTS technology could pool the resources that those connections use together. I also read that COM+ encapsulates this technology.

How do I make a COM+ object that allows my client-side app to take advantage of this pooling, or, is this already done via ADO or otherwise? I understand the concept but not the implementation.

 

[Palooka]

Check out these links:

How to Access SQL Server Within Active Server Pages

http://support.microsoft.com/support/kb/articles/q169/3/77.asp

How to Enable Connection Pooling in an ODBC Application

http://support.microsoft.com/support/kb/articles/Q164/2/21.ASP

Connection Pooling with ASP

http://www.15seconds.com/issue/970531.htm

Hope this helps,
Palooka

 

[VBXL]

Basically, when connecting to the SQL Server, you must keep the Username and password the same.

i.e. UID=user;PWD=knockknock;"

This way, using OLEDB, it will automatically pool your connections for you. You will not have to write extra code

If you use different Usernames and password, your connections will not get pooled efficiently

Xplain