If you are seeing this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen(CreateFile()). |
From ASP, you usually want to use TCP/IP, not Named Pipes. Make sure your network library is configured to use TCP/IP by default. If you have SQL Server installed, you can do this through the Client Network Utility (Programs/Microsoft SQL Server). Also, make sure you are using OLE-DB, not an ODBC driver. See Article #2126 for sample connection strings.
Named pipes can sometimes be stubborn, even after you have changed your network library. This could be because the remote server is overriding your local settings. To alleviate this, add the following line to your existing connection string:
<%
cst = cst & "Network=DBMSSOCN;"
%> |
Depending on which provider you are using, you may also need to try:
<%
cst = cst & "Network Library=DBMSSOCN;"
%> |
This might also be caused by a permissions issue. If changing to OLE-DB and TCP/IP does not seem to alleviate the problem, see KB #175671 and KB #328306.
[ Comment, Edit or Article Submission ]
