|iNTERFACEWARE Products Manual > Installing and Using Iguana > Working With a Database > Setting Up an Oracle Database Instant Client|
If you plan to use Iguana to obtain data from or store data into an Oracle database, and you do not have an existing Oracle client, the easiest way to interact with the Oracle database is with an Oracle Database Instant Client. This Instant Client enables you to establish an ODBC connection to your Oracle database.
To set up the Oracle Database Instant Client, you must:
To install the Oracle Database Instant Client:
The next steps are to ensure that the necessary Windows environment variables are defined. You will need to:
To define the necessary environment variables:
Next, you must create a tnsnames.ora configuration file for your Oracle Database Instant Client. This file should be located in the directory in which your Oracle Database Instant Client is installed (for example, C:\Oracle). The tnsnames.ora file should look like this:
In the definition shown above, replace MY_ORACLE_SOURCE with the name of your Oracle data source, replace hostname with the host name for your Oracle server, and replace portnum with the port on which your Oracle server is running.
The final step is to create a file named sqlnet.ora, located in the same directory as tnsnames.ora. In this file, add the following line:
This tells the Oracle client to time out if a connection to the Oracle server cannot be obtained within 5 seconds. (The default is to never time out, which can cause problems if the server is down or cannot be reached.)
Your Oracle client is now ready for use as an ODBC data source. See Setting Up an ODBC Data Source for Oracle for information on how to set up an ODBC data source for Oracle, and see Using an ODBC Oracle Data Source for information on how to use this data source in an Iguana channel.