Microsoft KB Archive/186726

= Error 80004005 Occurs When Retrieving Data from SQL Server =

Article ID: 186726

Article Last Modified on 6/22/2005

-

APPLIES TO


 * Microsoft Internet Information Server 4.0
 * Microsoft SQL Server 6.5 Standard Edition

-



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



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).



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=

to:

SERVER=(local)



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.

Additional query words: fetch structured query language source dsn akz

Keywords: kbprb kbpending KB186726

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.