Results 1 to 5 of 5

Thread: 10 years after

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: 10 years after

    Well...it's been 10 years since I've been in the Oracle Pond...

    Just Downloaded SQL developer...what do I need to do to supply a connection info
    Attached Thumbnails Attached Thumbnails OracleConnection.bmp  
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Connector is ...

    A database?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Name your connection and put in a username and password for your xe database
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    well duh

    what was the name of the file that we used to store all that stuff...do we still need to create that?

    And what about the SSID, HostName, Port, connection name (My name I guess)..UID and pwd I get

    anyone use the gui in the attachment?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by Brett Kaiser
    what was the name of the file that we used to store all that stuff...do we still need to create that?
    tnsnames.ora

    But with SQL Developer you don't need a tnsnames.ora (you don't even need an Oracle client, all you need is the JDBC driver)

    And what about the SSID, HostName, Port, connection name (My name I guess)..UID and pwd I get
    Only you can know the SID, hostname an port of your Oracle installation.

    The connection name is some descriptive name that describes where that connection points to (to distinguish multiple connections)

    More details are in the manual:
    http://download.oracle.com/docs/cd/E12151_01/doc.150/e12152/dialogs.htm#BACICJAF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •