How To Install Oracle Driver In Windows

Connect to Oracle from Windows with ODBC

• Introduction
• Connect to Oracle
• Setup ODBC
• Troubleshooting
• More than Information

Introduction

This article explains how to connect to Oracle with ODBC when using Windows 10.

It covers the following topics:

1. How to connect to Oracle (with lawmaking samples).
2. How to setup ODBC:
   • Configure ODBC using the ODBC Information Source Manager:

     We recommend using organization DSNs (available to all users).

Connect to Oracle [top]

We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.

Follow these steps to connect:

1. Create a new channel to try out the code:
   • Create a channel like this:
     • Name: DB Oracle Connection (or similar)
     • Source: From Translator
     • Destination: To Channel
   • Alternatively utilise an existing channel:

     Your channel volition need a From/To Translator or a Filter component.

2. Connect to a database using ODBC:
   • Paste this code into the Translator:

     If your script uses connection object methods conn:query{} or conn:execute{}to connect to a remote Oracle database, the location of the remote host is specified every bit part of the name parameter in the db.connect{ } command. If you employ conn:merge{} to connect the remote host is specified every bit part of the proper name parameter in the conn:merge{} control itself.

     function chief()       local conn = db.connect{          api=db.ORACLE_ODBC,        name='your_odbc_server_name',       user='your_login',       password='cloak-and-dagger',       use_unicode = truthful,       live = true    }     conn:execute{sql='SELECT * FROM <your table>', live=true} end

   • The name is the name of an ODBC source that y'all create using the ODBC Administrator.
3. Suit the code to your requirements.

Setup ODBC [top]

Note: Iguana may not e'er support the very latest version of Oracle drivers, so you tin can simply download an earlier version if necessary. This is particularly true if you are not able to employ the the latest version of Iguana.

If you need to know which versions of Oracle drivers are supported past the version of Iguana yous are using please contact us at support@interfaceware.com.

To fix up a new ODBC data source for Oracle Server:

1. Setup the Oracle instant client OCI drivers:

   The Oracle ODBC package depends on the OCI drivers — then you need to set them up first.

   • Follow the aforementioned process used for Oracle Easy Connect: Setup the Windows Oracle OCI drivers.
2. Install the latest Oracle ODBC drivers:
   1. Download the latest ODBC zip package from the Oracle instant customer download site:
      • Choose the latest Development and Runtime – optional packages > ODBC Package
   2. Unzip the ODBC zip package into the instantclient_X_Y folder where y'all installed the OCI drivers:
      1. Select the file in Explorer and choose Extract All:
         
      2. Browse and cull the folder containing the instantclient_X_Y folder where you installed the OCI drivers and click Extract:
         
      3. You should see the ODBC driver files in the instantclient_X_Y folder, something similar this:
         
   3. Open a command prompt as administrator:
      1. Search for "cmd".
      2. Right click Command Prompt and Choose Run as administrator:
         
   4. Concluding Command: Install ODBC:

      cd c:\Oracle\instantclient* odbc_install.exe

3. Open the 64 bit ODBC Administrator:

   Windows 10 (64 chip version) supports 32 and 64 chip ODBC sources — always use the 64 bit ODBC Ambassador.

4. Open the Organisation DSN tab and click Add:
   
5. Choose the latest Oracle ODBC driver and click Finish:
   
6. Enter the ODBC credentials:
   • Utilize whatever Data Source Name and Description yous prefer.
   • Enter the Network Name (or IP) of the Oracle Server in the TCP/IP Server field:
     Note: If you are unsure of this inquire your DBA (database ambassador).
   • Enter the Oracle service name in TNS Service Name:
     Note: If you are unsure of this ask your DBA (database administrator).
   • Enter the user login in the User ID field:
     Note: If you are unsure of this ask your DBA (database administrator).
   • Optional: Choose your default Database:
     
7. Examination the information source connection:
8. If the connection does not work speak to your DBA (database administrator) nearly how to login to the database (user authentication).

Troubleshooting [elevation]

• Problems with connection settings:

  Speak to your DBA (database administrator) for general connection problems like: User proper noun and password, Database Server network proper name etc.

• Iguana may not always support the very latest version of the ODBC drivers :
  

  Please contact us at support@interfaceware.com if yous need to know the latest supported version of the ODBC drivers.

  Login authentication errors:

  Authentication errors unremarkably relate to how the Oracle Server you are connecting to is setup. You volition need to talk to the DBA (database administrator) that manages the Oracle server.

• Using integrated security:

  If y'all wish to utilize Windows integrated security speak to your DBA (database administrator).

If you need more help please contact u.s. at support@interfaceware.com.

More than Information [top]

• Using Database Connectedness Objects
• Connect to Oracle with Easy Connect
• Connect to Oracle with OCI
• Connect to Oracle from Linux or Mac with ODBC

Source: https://help.interfaceware.com/v6/connect-to-oracle-from-windows-with-odbc

Posted by: goffpubleausing1958.blogspot.com

Share this post