Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question: How can one tell others how to connect to its Oracle database

Re: Question: How can one tell others how to connect to its Oracle database

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 28 May 2004 22:34:03 -0700
Message-ID: <1085808850.978534@yasure>


lev wrote:

> Hello,
>
> Here's the scenario. I am a Windows service. I use an Oracle database
> via ODBC. I want to tell others how to connect to my Oracle database
> from other machines. All I know is ODBC DSN that I use to connect to
> Oracle.
>
> I am a part of a commercial software package. My owners are free to
> use whatever name resolution scheme they fancy. Thus this ODBC DSN can
> contain a local name, a name resolved by a naming service, or a full
> connection string.
>
> Trouble is local names. They are useless to anyone but me. How do I
> turn this local name it into something that others can use? Parse
> tsnnames.ora? Moreover how can I tell if it's local name? May be it's
> a name resolved centrally?
>
> Any ideas are highly appreciated.
>
> Lev.

Contact your DBA.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat May 29 2004 - 00:34:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US