keep _ConnectionPtr effictive

Question

0.00/5 (No votes)

See more:

my problem is i write a dll（the dll is connect to the sql server database to get records) if the MSSQLSERVER is up,my dll work good。 but when i restart MSSQLSERVER servers ,dll don't work 。when the dll init,it will connect to the database.but when the MSSQLSERVER restart,the ADODB::_ConnectionPtr m_pConnection don't change. so how do i keep the m_pconnection is effiective(keep connection the database) uing a timer to keep? or.......

Posted 16-Jul-13 19:49pm

chinaprogramer

Add a Solution

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)

KarstenK · Answer 1 · 2013-07-17T00:37:00

if the connection gets lost, you will fetch some exceptions on the next operations. Check them and reconnect.

Export some functions from the dll to enhance your interface.

A timer is bad. You better set good values for that on the database.

And dont ferget: bad things can happen, so prepare to resume from errors.