Re: Challenge for experts!!!!!!!!!!!!!!

Thanks a lot
Sybrand

But my problem is that before my application actually connect to the database , I want to check that the Oracle service is either runnig or not on the server.
So that is why I need either server name or IP address.

Actually server name can solve my problem IP address is not neccessary.

Now you may understand my problem.

To me the only solution is that I have to write a module that read the tnsnames file and get the server_name for that specific Oracle TCP/IP service.

IS there any othet solution(easy) ???? :))

thanks

Faheem Rao

In article <91qr15$4pm1t$6_at_ID-62141.news.dfncis.de>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> As you, IIRC, *never* included platform and version info, and the
 answer is
> going to be platform and version specific, how do you expect to get a
> response?
> Also, stay away from the IP-address: they change.
> Do not use the IP address in tnsnames.ora. It does work, but it is not
> endorsed by Oracle.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <faheemrao_at_my-deja.com> wrote in message news:91qpg7
 $9uv$1_at_nnrp1.deja.com...
> > I have put this question on deja soo many times but, no one is
 there
> > to get a solution for me.
> >
> > I want to know that what is the host name an oracle ODBC data
 source
> > (using Oracle ODBC driver) through registry. But Oracle ODBC data
> > source does not provide such information in the registry. I know
 that
> > its information is stored in the tnsnames file.Only the service is
> > stroed in the registry.
> >
> > But actual problem is that I want to get the host IP adress form
 the
> > C++ application.
> > Any body tell me that from where I can get that Ip address of the
 ODBC
> > data Source.
> > I know that I can get this Information through a C++ module that
 read
> > the whole tnsnames text file.
> >
> > Is there any other easy solution.??
> >
> >
> > thanks in advance
> >
> >
> > Faheem Rao
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 12:25:08 CST