Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Location
    Madison, CT
    Posts
    2

    Unanswered: Listing available DBs

    Is there a command I can use in a powerbuilder program to get a list of available databases?

    Thanks,
    Dan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there a command I can use in a powerbuilder program to get a list of available databases?
    It depends, but probably not & in any case would be OS dependent.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    You should be a little more specific in what you are trying to do Dan.

    Are you trying to find out the databases that reside on the machine, or are you trying to scan a network for "available databases"??? Or, are you assuming that Oracle operates in the same way that SQLServer does and puts multiple "databases" into a single instance of the server?

    JoeB

  4. #4
    Join Date
    Sep 2004
    Location
    Madison, CT
    Posts
    2
    Quote Originally Posted by joebednarz
    You should be a little more specific in what you are trying to do Dan.

    Are you trying to find out the databases that reside on the machine, or are you trying to scan a network for "available databases"??? Or, are you assuming that Oracle operates in the same way that SQLServer does and puts multiple "databases" into a single instance of the server?

    JoeB
    Actually it was suggested to me that I add a list of available DBs to an app like some other apps (toad, sql nav...) but I guess those tools are just listing your connection history. So I guess you can disregard my original question.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by everkleer
    Actually it was suggested to me that I add a list of available DBs to an app like some other apps (toad, sql nav...) but I guess those tools are just listing your connection history. So I guess you can disregard my original question.
    You'll probably need to parse tnsnames.ora - at least that's where I think TOAD gets its list of databases...

Posting Permissions

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