Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I know that Oracle server installed on this machine in my app?

Status
Not open for further replies.

cyberdyne

Programmer
May 1, 2001
173
IN
Hi all ,

I am developing an application in VB6. I want to know that the machine on which this appication is installed has Oracle8 Server or Oracle Client through the application so that I can enable or disable some feature.

Pls help asap.

Regards
and thanks in advance.

From:
Apoorva Gala
You can mail me at apoo1972@rediffmail.com
 
If any one can provide me some information from where do i get this info would also be helpfull. From:
Apoorva Gala
You can mail me at apoo1972@rediffmail.com
 
I'm using Oracle 8.1.6 and OO4O. Here is how I dectect if Oracle is installed in the machine where my program is run.

Right after you create the Session if error occurs, you know OrcaleInProcServer cannot be created because Oracle is not installed. You can goto HandleError to handle it or doing something.

Set Session = CreateObject("OracleInProcServer.XOraSession")
If Err.Number <> 0 Then
MsgBox &quot;Oracle Object For Ole Is not installed&quot;
End If

Hope this might help.

-kendel
 
This did not serverd my purpose.

What I want to know is whether the application installed on the machine has Oracle Server installed on it or it has oracle client installed on it ?

How do i check this ?

thanx From:
Apoorva Gala
You can mail me at apoo1972@rediffmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top