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

If else condition between table ,how it will use (8h)

SELECT STUFF returning incorrect values (9h)

Structre to link 2 tables and use the link for multiple tables (1d)

Hierarchy - Rows to columns (1d)

Exam retakes policy (1d)

Sub Query Not Cooperating (2d)

Ssrs 2012 date formatting (2d)

Basic SQL join issue (3d)

- Advertisement -