Database Error : Connection Failure

Question

2.67/5 (3 votes)

See more:

I have a program that get/update data in sql server(as my database).
Whenever i run my looping in my program before it will done, the error message will pop out that says: "Connection Failure" that will stop my program from processing.

Can somebody share any suggestion regarding this type of bug in my application.
How can i solve or avoid the process to come to this kind of error.???

Any suggestion will be appreciated..

Thanks..

Posted 3-Feb-12 0:41am

jdandes

Add a Solution

Comments

Sridhar Patnayak 3-Feb-12 6:46am

Not clear, Which loop, and what it's doing? please provide little bit or code. Otherwise it is difficult to answer

uspatel 3-Feb-12 6:46am

share code.....

ZurdoDev 3-Feb-12 8:11am

Need to see code but you probably just need to add breakpoints and step through your code until you find what is happening.

Simon_Whale 3-Feb-12 12:04pm

guessing I would say your code closes the connection while in the loop. To help more please post the code that is causing the error

[no name] 3-Feb-12 17:38pm

this seems right..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-02-05T10:31:00

Solution 1

No-one who doesn't hate themself, still uses VB6. That is why you will struggle for help. It would help you to post code, otherwise, you have no real chance, IMO.

Posted 5-Feb-12 10:31am

Christian Graus