I have a databse running on SQL server on Machine 1.
When I try to access the ASP which queries this databse from the same machine, I SOMETIMES get the above error. This is resolved by restarting IIS on my machine.
Secondly when i try to access the same from database from Machine 2 on my network I SOMETIMES get the above error while at other times I get (0X80004007)
Any clues as to why this is happening??
I need to automate certain tasks but cannot do so without getting these errors rectified.
Apprecial suggestions at the earliest!