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

Does the EdbMails support attachment recovery? (3h)

SQL Setup (12h)

DW Design help (1d)

Composite indexes and best practice for Interval-valid values (1d)

Need help writing SQL query to find value from a table based on two specific values (2d)

Backup history not showing - Sql server 2012 (2d)

Get the latest person initial last entered by date....REVISED (2d)

SQL Query singular column date as at today (2d)

- Advertisement -