Help and Support

Error 80004005 Occurs When Retrieving Data from SQL Server

Article ID:186726
Last Review:June 22, 2005
Revision:3.1
This article was previously published under Q186726
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:
http://www.microsoft.com/technet/security/prodtech/IIS.mspx (http://www.microsoft.com/technet/security/prodtech/IIS.mspx)

SYMPTOMS

When using Active Server Pages (ASP) to retrieve data from a Microsoft SQL Server database, the following error occurs:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionWrite
(GetOverLappedResult( )).

Back to the top

WORKAROUND

If SQL Server is running on the same server as Internet Information Server (IIS), use a local named pipe connection instead of a network named pipe connection.

In the SQL Server connection string, DSN configuration, and Global.asa file, change
   SERVER=<computername>
				

to:
   SERVER=(local)
				

Back to the top

MORE INFORMATION

The name "(local)" (with parentheses, but without quotation marks) is a special keyword recognized by the SQL Server ODBC driver; it indicates that a local connection should be used.

Back to the top


APPLIES TO
Microsoft Internet Information Server 4.0
Microsoft SQL Server 6.5 Standard Edition

Back to the top

Keywords: 
kbprb kbpending KB186726

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.