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:
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=<computername>
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