Error while connecting database -1

When i try to connect my application it retruns this error 'Error while connecting database -1 --A sql server request resulted in a bad return code or status but no error message was returned'.But when second time i try to connect the application opens.this error message appears randomly not regularly..can anyone help me for this.Here attches the error image.
Error.jpg
itssooAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
which language are you using to connect to sql server? can you please show me connection string?
0
 
RiteshShahCommented:
why language are you using for getting connection? Perl, asp, asp.net or something else.
0
 
tpi007Commented:
Most likely this error indicates a problem not with sql server itself but either the client, or connectivity. Try installing the latest version of MDAC from Microsoft

http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e  
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
itssooAuthor Commented:
Power builder 8
0
 
RiteshShahCommented:
update to latest SP of sql server
0
 
RiteshShahCommented:
latest MDAC also? as per tpi007's post
0
 
itssooAuthor Commented:
I already installed Sp4 and Microsoft Data Access Components (MDAC) 2.8 SP1 but still the same error.Bu the thing is that this error comes in the server only.not in the client machines.
0
 
itssooAuthor Commented:
thanks for the help.it's service pack problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.