Export (0) Print
Expand All

How to Install the Oracle Client for BizTalk Adapter for Oracle Database

To use Oracle and Microsoft BizTalk Adapter for Oracle Database, you must install an Oracle client. The Oracle client installation includes the Oracle ODBC driver.

Oracle 9.2 only: the ODBC driver that is installed with the Oracle 9.2 client contains a bug that prevents the enumeration of items that have Japanese characters.

The ODBC connection requires that the database service name and data source name to be the same. These names must match the Net8 (called SQL*NET before Oracle8) local net service names created for the Oracle system. If one name is used in Net8, and the name is used throughout a project, you must use this name if deploying the solution to another computer. For more information, see the Oracle documentation about how to set up NET8 local net service names.

To use Oracle with the BizTalk Adapter for Oracle Database you must install the Oracle client on your computer.

To install the Oracle client
  1. Run the Oracle client Setup, setup.exe.

  2. On the Installation Types page, select Administrative, and then click Next.

  3. On the Oracle MTS Recovery Service Configuration page, accept the default (or set your own) port, and then click Next.

  4. On the Install screen, click Install.


    The Oracle client installs. The Oracle .Net Configuration Assistant finishes the typical configuration setup. You can create a net service name yourself.

  5. On the Welcome screen, click Next.

  6. On the Database Version page, select 8i or later versions, and then click Next.

  7. On the Service Name page, enter the service name that was set up in the Oracle server, for example, vis, and then click Next.

  8. On the Select Protocols page, select your protocol, and then click Next.

  9. On the TCP/IP Protocol page, enter the following information, and then click Next.

    • Host name: Host name of the computer for the database, for example, Oracle11x.

    • Port number: Select to keep the default port or change it to one that has been set for you, for example, 1523.

  10. Continue through the wizard until you can click Finish to complete the setup.

    After clicking Finish, you can verify that ODBC for Oracle is installed by using the ODBC Data Source Administrator. In Control Panel, open Administration Tools, and then open Data Sources (ODBC).

Community Additions

© 2014 Microsoft