oshe127
asked on
ODBC SQL Server Driver Named Pipes
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;p wd=xxxxxxx ;database= xxxxxxx"
What could have cause their application to stop working just because they added some Microsoft Windows patch.
URGENT - Thank you!
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
What could have cause their application to stop working just because they added some Microsoft Windows patch.
URGENT - Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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.
The IP was half of the problem the other half was the global.asa, didn't have the cluster name it still said local.
CHeers