4 Replies Latest reply on Dec 12, 2012 1:36 PM by 979432

    Generic Connectivity, missing agents


      I have been trying to setup generic connectivity on my Oracle Database. After a while I have noticed that I am missing the executable agent files in the $ORACLE_HOME/BIN path. Can anybody tell me how can I now use the generic connectivity with an OLEDB agent, as I am missng the hsolesql agent?. I have found that dg4odbc can be used instead of hsodbc but no information about hsolesql. My Oracle and Windows version is mentioned below.

      Many thanks,

      Oracle Database 10g Enterprise Edition Release - 64bit
      PL/SQL Release - Production
      CORE Production
      TNS for 64-bit Windows: Version - Production
      NLSRTL Version - Production
      Windows Server 2008 R2 Enterprise
        • 1. Re: Generic Connectivity, missing agents
          HSODBC was never ported to 64bit Windows, that's the reason why you don't find an executable.

          In addition HSODBC was desupported in March 2008 and replaced by a follow up product called Database Gateway for ODBC. This gateway is available as release and ported now to 64bit Windows.

          You can download the gateway product from My Oracle Support Portal (=MOS -> see also support.oracle.com). Please click on the Patches and Updates section and look for Patch 10404530: PATCH SET FOR ORACLE DATABASE SERVER. Make sure to choose as platform MS Windows 64bit. According to the readme the Oracle Gateways CD is p10404530_112030_platform_5of7.zip. Download this ZIP file and extract it on the Windows machine where you want to install the gateway. Use the Oracle universal Installer to install the product into its OWN, separate Oracle_home directory. Please do NOT install the gateway into the existing database home as it will corrupt your existing database installation.

          The configuration of DG4ODBC is similar to your HSODBC config, but there's also a note available through MOS: How to Configure DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems to Connect to Non-Oracle Databases Post Install          [Document 1266572.1]     

          - Klaus
          • 2. Re: Generic Connectivity, missing agents
            Many thanks for the explanation Klaus. I will surely go through the documentation. Is there something like Oracle Database Gateway for OLEDB (not ODBC) - a replacement for the missing hsolesql?. The non-Oracle datasource should be connected via OLEDB.

            • 3. Re: Generic Connectivity, missing agents
              Hi Wojtek,
              unfortunately this option has been dropped completely. OLEDB is not longer available, only ODBC. And just as another info, when running on a 64bit platform, DG4ODBC is 64bit and it requires a 64bit ODBC driver.
              • 4. Re: Generic Connectivity, missing agents
                Many thanks Klaus for your help.