5 Replies Latest reply: May 14, 2012 7:26 AM by Michael Ferrante-Oracle RSS

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

    933940
      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
          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
            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
              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
                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
                  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.