This discussion is archived
5 Replies Latest reply: May 14, 2012 5:26 AM by Michael Ferrante (Oracle) RSS

How to connect Forms 6i & Reports 6i with oracle 10g R2?

933940 Newbie
Currently Being Moderated
Hey everybody,

I need your help in connecting both Forms 6i & Reports 6i with Oracle 10g Release 2 db, MS Access(2003, 2007) and SQL database(Microsoft Visual Studio 2008). I am a newbie. I have installed all of them on my HP notebook, with Windows 7 Ultimate(32 bit OS) installed. I want to generate forms & reports by accessing data from above mentioned databases. Please provide me with the configuration steps.

Thanks in advance...!
  • 1. Re: How to connect Forms 6i & Reports 6i with oracle 10g R2?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    Welcome to the forum ;-)

    Please be sure to review the following:

    http://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo

    First, I think it would be a good idea if we can understand why you have chosen to use a nearly new operating system yet install Oracle products that are 10 years old (i.e. Forms/Reports 6i) on it. In general, this is not a good idea. Although running such an old version on Win7 can be made to work, the possibility of having problems is likely. If you are infact new to the product, using a configuration where you are likely to have problems may not be a good starting place. Also, you should be aware that Forms/Reports 6i was desupported several years ago. Documentation and other information is gradually being replaced by newer information, so resources for this old version are going away. The latest version of Forms/Reports is part of Fusion Middleware 11R2 (version 11.1.2.0) and requires WebLogic Server 10.3.5 (or 10.3.6) in order to be installed.

    Second, if you decide to stick with F/R 6i, are you planning to run the applications you create in a browser or as a client/server application? This information is important because how you connect to a database will slightly differ depending on which option you choose. Also, if you want to connect to non-Oracle data sources you can use ODBC for client/server or Oracle Transparent Gateway. However, if you plan to deploy the applications using a browser, Gateway is your only option for connecting to non-Oracle datasources. As for connecting to MS Access, I believe ODBC is your only option, so web deployment may not be an option.

    http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/ch1.htm

    There are many other references available. Try a Google search.

    As for connecting to an Oracle database, this is generally easy. For the Builder(s) and client/server runtime to connect, add the db information to the tnsnames.ora found in the Oracle Home (installation directory) \network\admin. If you are unfamiliar with what goes in the file you can copy the entries created for your database. The db will have a similar file found in a similar place in its installation directory (Oracle Home). For example, you might find something like this:
    ORCL =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = YOURSERVER.COM)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
    )
    Simply copy this information to the end of your tnsnames.ora found where Forms/Reports is installed then restart any running Forms or Builders.
  • 2. Re: How to connect Forms 6i & Reports 6i with oracle 10g R2?
    CraigB Guru
    Currently Being Moderated
    I want to generate forms & reports by accessing data from above mentioned databases.
    Well, first and foremost - Oracle Forms/Reports is designed to connect only to an Oracle database. If you want to connect to a non-Oracle database you will have to configure Heterogeneous Services in your Oracle Database - if your edition supports this. This enables the Oracle database to connect to non-Oracle databases. Once you have this configured and you are able to read/write to the non-Oracle database from your Oracle database, then and only then, will you be able to use Oracle Forms/Reports to use the non-Oracle databases.

    To learn more about Hetergeneous Services just search "Oracle Hetergeneous Services" using your favorite Search engine or click here: Oracle Heterogeneous Services.

    Hope this helps,
    Craig B-)

    If someone's response is helpful or correct, please mark it accordingly.
  • 3. Re: How to connect Forms 6i & Reports 6i with oracle 10g R2?
    933940 Newbie
    Currently Being Moderated
    Thank you Mr. Micheal Ferrante for your reply..

    For now I'll listen to you and connect Forms & Reports 6i with just Oracle 10G.
    I followed your steps and found three files with the name tnsnames.ora in the following locations:

    c:\orant\net80\admin

    c:\orant\net80\admin\sample

    c:\orant\net80\tnsapi

    Now please tell me which file you want me to copy paste your given code?

    After modifying that file, would you please tell me how to test the connection ?

    After the successful connection would you mind teaching me a sample of Form as well as Report ?

    I know that the way I'm asking you all these things is kinda childish or you can say not professional but please help me.
    Thanks in Advance!!
  • 4. Re: How to connect Forms 6i & Reports 6i with oracle 10g R2?
    937094 Newbie
    Currently Being Moderated
    c:\orant\net80\admin

    c:\orant\net80\admin\sample

    c:\orant\net80\tnsapi

    Now please tell me which file you want me to copy paste your given code?

    After modifying that file, would you please tell me how to test the connection ?

    After the successful connection would you mind teaching me a sample of Form as well as Report ?


    http://01objects.com

    Edited by: 934091 on May 14, 2012 12:20 AM
  • 5. Re: How to connect Forms 6i & Reports 6i with oracle 10g R2?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    Being new to the forum, I encourage you to review the following before posting much more:

    http://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo

    As for your issue, I hope that you are carefully reading my posts.

    Like I mentioned, Forms/Reports 6 is very old and the operating systems you suggested you will be using are very new. This version of F/R is obsolete and expecting it to work on a new OS is not realistic. Why are you spending time with such an old version? Even if you are just trying to learn the product, trying to learn with an old version is probably not a good idea.

    The tnsnames.ora file you need to update is this one: c:\orant\net80\admin

    If you want to learn how to use the product in detail, you likely will not be able to do it in a forum. This is not like trying to learn MS Notepad. Forms/Reports (and all Oracle products) are enterprise level products. Any of the Oracle products would require that you spend some time reviewing the documentation and in many cases attending some courses in order to ever be effective using them. You can find documents and training in countless places including within the Oracle site. I recommend you consider that as your starting place.

    Here are just a few example:

    Forms Technical Papers for most versions:
    http://www.oracle.com/technetwork/developer-tools/forms/overview/index.html

    Forms 11.1.2 Documentation Library:
    http://docs.oracle.com/cd/E24269_01/index.htm

    Archived Forms Documentation:
    http://www.oracle.com/technetwork/documentation/dev-arch-093406.html

    Oracle Forms - Oracle Education
    http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=501

    The Forms and Reports Builder Online Help is also a good place for information as in some cases, example code is provided.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points