Oracle Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Oracle Adapter

Viewing 1 reply thread
  • Author
    Posts
    • November 7, 2005 at 3:22 PM #12211
      community-content

        Hi,

        I’ve installed BizTalk utilities, and the Oracle client because I would like to create an Oracle adapter!
        It was an error, I’ve installed Oracle 10g Data provider for .Net 10.1.0.4.0 including ODAC, it contains:

        a) Oracle Data Provider for .NET (10.1.0.4.0)
        b) Oracle ODBC Driver (10.1.0.3.1)
        c) Oracle Provider for OLE DB (10.1.0.4.0)
        d) Oracle Objects for OLE (10.1.0.5.2)
        e) Oracle Services for Microsoft Transaction Server (10.1.0.4.0)
        f) Oracle Client (10.1.0.2.0)
        g) Oracle Universal Installer (10.1.0.4.0)

        But there is always the same error:
        ———————————————————————————–
        Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
        Provider is unable to funcion until these components are installed
        ————————————————————————————

        Could you help me PLEASE ??? I need your help!

        Thank you in advance
        A. C.

      • November 8, 2005 at 7:32 AM #12212
        community-content

          Yes,

          It should be compateble, because I installed BizTalk Utilities, which contains an Oracle Adapter, but It’s said that we should install an Oracle client!

          That’s what I’ve done, but there is always the same error message 🙁

          The responsible of bizTalk Utilities who sent me the license file sais that I had to install the version 10….

          I sent him an e-mail, and he replied:
          \”I’m assuming that you did set up the TNS for the Oracle Data Source etc.
          I think you’re facing a permissions problem here. Give everyone access to the Oracle folder including its subfolders\”

          I tried to check it but nothing 🙁

          what am I doing wrong ?!? :-((

          • November 8, 2005 at 7:55 AM #12213
            community-content

              Hi,

              I have another question:

              shouldn’t I set the library loading path to point to the directory where I unzipped and installed the oracle client ????

              what do you think??

              • November 8, 2005 at 12:58 PM #12214
                community-content

                  Hi,

                  I made a mistake, because I forgot to install Oracle Services for Microsoft Transaction Server.

                  Now I don’t have this error message any more, but I have a new one 🙁

                  ———————————–
                  Test connection failed because of an error in initializing provider. ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
                  ———————————-

                  do you know where I have to go for initializing the provider??

                  Thank you in advance!
                  A.C.

                  • November 8, 2005 at 5:51 PM #12215
                    community-content

                      Hi,
                      yes, you are right, the problem comes from tnsnames.ora, because it doewn’t find any datasource!

                      So you should create a data source from the Oracle Net manager and configure in Microsoft ODBC Administrator !!

                      Then the connection is ok

                      kind regards

                      AC

                      • November 7, 2005 at 11:07 PM #12216
                        community-content

                          Is the Oracle Adapter you are trying to use compatible with Oracle 10g?

                          I know the Microsoft Adapter for Biztalk 2006 (a.k.a. iway adapter) is but there are a lot of other Oracle Adapters out there.

                          You might be better off contacting the vendor.

                          • November 8, 2005 at 3:48 PM #12217
                            community-content

                              About the only think I know about Oracle is to got to \\Network\\Admin and update the tnsnames.ora file.

                              Best of luck.

                • Author
                  Posts
                Viewing 1 reply thread
                • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.