Home » RDBMS Server » Networking and Gateways » how to judge the oracle service is available (9i)
how to judge the oracle service is available [message #421155] Fri, 04 September 2009 10:35 Go to next message
yugiant
Messages: 1
Registered: September 2009
Junior Member
Hi
Now i use ado to connect oracle in vc++,but if the oracle service is down,the program is no response
So i want get a method to judge if the oracle service is available,and then run the program,otherwise show a message of quit the program.

Now i use:
m_pConnection->Open("Provider=MSDAORA.1;Data Source=orasrv;","user","user123",adModeUnknown);
if m_pConnection->State==0 .......

but if the oracle service is down,the program is waitting
how can i work out my program to get a good method
thanks a lot
Re: how to judge the oracle service is available [message #421161 is a reply to message #421155] Fri, 04 September 2009 11:04 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


I think NO one going to help you. Please raise your question to Microsoft forum.

Babu
Re: how to judge the oracle service is available [message #421165 is a reply to message #421155] Fri, 04 September 2009 12:01 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Oracle driver.

Regards
Michel
Previous Topic: 12560: TNS
Next Topic: Network connection ways of debugging web report on different operating systems with VMware
Goto Forum:
  


Current Time: Fri Apr 19 06:55:22 CDT 2024