MDAC in Motion

By Bill Graziano on 26 November 2001 | Tags: General


With Microsoft playing musical chairs with its default behaviors under MDAC, Web application developers building for the IIS (Internet Information Server)/ASP (Active Server Pages) platform will need to take greater care when updating core OS data-access components on existing servers.

Microsoft's decision to change the default behavior of the Network Library parameter in MDAC 2.6 and MDAC 2.7 will force developers to make a conscious choice regarding which library to employ. TCP/IP (the new default) is faster than Named Pipes (the old default), but it also consumes more CPU cycles per transaction, and the processing overhead that can lead to scalability problems down the road.

Link: MDAC in Motion


Related Articles

How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 (5 March 2007)

Visual Studio 2005 Team Edition for Database Professionals (5 June 2006)

SQL Server/Visual Studio/BizTalk Connected Systems Developer Competition (30 May 2005)

Microsoft Developer Survey (9 December 2004)

MS Best Practices Analyzer Released (26 May 2004)

Appropriate Uses of MSDE (11 October 2002)

MSDE Information and Requirements (25 March 2002)

Oracle vs. SQL Server - An Issue Of Complexity (10 June 2001)

Other Recent Forum Posts

Transfer to new windows 11 computer (4d)

Pivot data but keep equal number per metric (8d)

Change Font Size In T-SQL Message Window? (9d)

Who has joined and who has left (11d)

Linked Server Selection Query Fails with "MS DTC has stopped this transaction" (14d)

Query almost perfect but brings wrong record (15d)

Installing integration Services with Web edition (17d)

Can I add dynamic WHERE clause to this query? (17d)

- Advertisement -