Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Pune, India

    Unanswered: (C:\)Forms not connecting to DB (db on F:\)


    I have forms 6i installed on C:\ and Oracle 9i Databse installed on F:\

    Its allowing me to access the db properly thru sqlplus with user/pwd@hoststring fasion. but the same is not happenig with forms.

    There are other oralce hosts on other drive of laptop. BUt i ahve made the same entry for my hoststring in all hte tnsnames.ora files there on the laptop.

    still its not able to connect wtih thedatabase. it says - cant resolve the hoststring. The meaning of hte error is clear to me. But i dont understand why such an error is happenign whe n i have entered the hoststring def inall the thsnames...

    thanks in advance for replies

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >I have forms 6i installed on C:\ and Oracle 9i Databse installed on F:\
    By loading two different Oracle products on the same PC,
    you have two ORACLE_HOME trees and two TNSNAMES.ORA files.
    If/when the TNSNAMES.ORA file under the Forms tree does not contain
    an entry for the database, then Forms can't locate the DB;
    even though it is right next door.
    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.

Posting Permissions

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