Solved

ODBC SQL Server Driver Named Pipes

Posted on 2002-05-07
5
1,058 Views
Last Modified: 2008-02-26
My client added some Microsoft Windows patches over the weekend and now their application is not working.  Their SQL Server Database is set up on a cluster.

This is the error that my client came up with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not
found.

This is what I have in the global.asa for the connection string:
Session("strUConnect")  = "Driver={SQL Server};Server=(local);uid=xxxxxxx;pwd=xxxxxxx;database=xxxxxxx"

What could have cause their application to stop working just because they added some Microsoft Windows patch.

URGENT - Thank you!

0
Comment
Question by:oshe127
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 6

Accepted Solution

by:
curtis591 earned 100 total points
ID: 6994005
if you run cliconfg.exe is has the default communication for your sql server entry been changed to named pipes.  I am guessing if you switch it to IP it will work.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6994008
Check out the Server and Client Network tools from SQL Server, there you can see which network protocols are enabled. Normally, you choose the TCP/IP as default protocol (at the server and at the client), and it should work fine. I guess that the patch has reset the default to named pipes (silly NT)...

CHeers
0
 

Author Comment

by:oshe127
ID: 6994025
We are having them check the utility now for TCP/IP and they are adding the exact name of the cluster in the server instead of it being local.
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 6994204
You don't give away the versions of SQL/OS that are being used but you might want to checkout the Q article that documents rebind.exe Q239473 after OS updates.
0
 

Author Comment

by:oshe127
ID: 6994610
Thanks!

The IP was half of the problem the other half was the global.asa, didn't have the cluster name it still said local.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query for highest sequence 4 60
How to handle time out inside the stored procedure 10 24
Need help with another query 10 35
SQL Syntax 6 37
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question