Error 80004005 Occurs When Retrieving Data from SQL Server (186726)
The information in this article applies to:
- Microsoft Internet Information Server 4.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Minor | Last Reviewed: | 6/22/2005 |
|---|
| Keywords: | kbpending kbprb KB186726 |
|---|
|