Results 1 to 7 of 7

Thread: not able to connect oracle form builder

  1. #1
    Join Date
    Jul 2006
    Posts
    1

    not able to connect oracle form builder

    I am able to connect to the oracle database but i am not able to connect to the oracle 10g form builder which uses the same username and password. Can anyone plase let me know if anything has to be done in net-configuration assistant

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    No, you don't have to use Net Configuration Assistant. All you need to do is point Developer Suite to the same set of configuration files you use for SQL*Plus.

    http://www.databasejournal.com/featu...le.php/3108301

    One huge misconception about using Oracle products that occurs among other-than-RDBMS users (novice Forms developers in particular) has to do with the proper configuration of the non-RDBMS Oracle product. This is probably the number one problem or misconception you can easily find on numerous web sites: "I can connect to my database when using SQL*Plus. I just installed Forms & Reports and my forms can't connect to the database. What gives?"

  3. #3
    Join Date
    Aug 2006
    Posts
    1

    Arrow

    Quote Originally Posted by sgsapna
    I am able to connect to the oracle database but i am not able to connect to the oracle 10g form builder which uses the same username and password. Can anyone plase let me know if anything has to be done in net-configuration assistant
    ans
    just try that
    copy the tnsnames.ora file from orc 10g folder on os
    and find tnsnames.ora in form folder on os (where the form installed ) replace it .
    just try it will work.

  4. #4
    Join Date
    Nov 2007
    Posts
    1
    Quote Originally Posted by orasantosh
    ans
    just try that
    copy the tnsnames.ora file from orc 10g folder on os
    and find tnsnames.ora in form folder on os (where the form installed ) replace it .
    just try it will work.

    I was having the same problem, don't read the article....just do as orasantosh said above. It works like a charm. The database field by default should be orcl. The user and password...well you should know those.

  5. #5
    Join Date
    Oct 2005
    Posts
    2,557
    Quote Originally Posted by danceuport
    I was having the same problem, don't read the article....just do as orasantosh said above. It works like a charm. The database field by default should be orcl. The user and password...well you should know those.

    Which is what I said over 16 months ago:
    All you need to do is point Developer Suite to the same set of configuration files you use for SQL*Plus.

  6. #6
    Join Date
    Dec 2007
    Posts
    6

    oracle forms 9i/10g connecting SQL Server

    Could anyone please guide me in detail to connect Oracle Forms 9i/10g with MS SQL Server database?

    Also how do we connect with other databases like SQL Server, MS Access, and so on?

    Thanks in advance.

  7. #7
    Join Date
    Dec 2007
    Posts
    3

    common tnsnames.ora problem

    Sounds like the tnsnames.ora file is missing from the folder or path

Posting Permissions

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