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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: connect to the databases without using tnsnames.ora?

Re: connect to the databases without using tnsnames.ora?

From: ltiu <ltiu_at_alumni.sfu.ca>
Date: Fri, 06 Sep 2002 10:18:36 -0800
Message-ID: <F001.004CA16C.20020906101836@fatcity.com>


Actually, I am talking about my experince with Forte for Java. When establishing a connection to a database using a GUI. It will ask you for the username, password and SID as well as server name or IP address, and then it connects. I am completely oblivious as to where it keeps the parameters I have given it to I'm assuming it stores it somewhere. Not strictly a tnsnames.ora file but a config file somewhere that's specific to Forte. I also have the same experience with JDeveloper.

What I meant is that JDBC itself does not use tnsnames.ora but something like it. Thanks for clarifying.

ltiu

Naveen Nahata wrote:

>JDBC Oracle thin driver DOES NOT require any config file.
>
>The connection url needs to be of the form jdbc:oracle:thin:@host:port:SID
>
>Naveen
>
>-----Original Message-----
>Sent: Friday, September 06, 2002 9:33 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Are you talking about the JDBC Oracle Thin Driver?
>
>This is because you configure it separately. It still has a tnsnames.ora
> type config somewhere hidden in it's own config file. Just that it does
>not use the regular tnsnames.ora.
>
>ltiu
>
>DENNIS WILLIAMS wrote:
>
>
>
>>Cc
>> I believe the Java thin client can connect without using the
>>tnsnames.ora file.
>>
>>Dennis Williams
>>DBA
>>Lifetouch, Inc.
>>dwilliams_at_lifetouch.com
>>
>>
>>-----Original Message-----
>>Sent: Thursday, September 05, 2002 8:23 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Does anyone here knows how to setup the connections to
>>the database server without using tnsnames.ora?
>>
>>Our DBA didn't use it. But I don't know how and why?
>>Could anyone tell me the other options?
>>
>>Cc Harvest
>>
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Yahoo! Finance - Get real-time stock quotes
>>http://finance.yahoo.com
>>
>>
>>
>>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Sep 06 2002 - 13:18:36 CDT

Original text of this message

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