nepalnomad.blogg.se - Oracle odbc driver configuration tns service name

#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME INSTALL#
#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME DOWNLOAD#
#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME WINDOWS#

The tnsnames.ora file should look like this: MY_ORACLE_SOURCE = This file should be located in the directory in which your Oracle Database Instant Client is installed (for example, C:\Oracle). Next, you must create a tnsnames.ora configuration file for your Oracle Database Instant Client.

Click OK to close the System Properties window.

Click OK again to close the Environment Variables window.

Click OK to close the Edit System Variable window.

Append a semi-colon to the list, then type the directory that contains your Oracle Database Instant Client.

In the Edit System Variable window, in the Variable Value field, position your cursor at the end of the current list.

Select the PATH environment variable, and click Edit.

(If it does not exist, create it using the steps that you used above to create TNS_ADMIN.)

In the System variables panel, locate the variable named Path or PATH.

The Environment Variables window is now displayed again.

Click OK to create the environment variable.

In the Variable Value field, type the name of the directory that contains your Oracle Database Instant Client (for example, C:\Oracle).

In the Variable Name field, type TNS_ADMIN.

In the System variables panel, click New.

From Windows, open the Control Panel and click System.

To define the necessary environment variables:

Ensure that the directory that contains the Oracle Database Instant Client is included in the PATH environment variable.

Create an environment variable named TNS_ADMIN, and set its value to be the directory that contains the Oracle Database Instant Client (for example, C:\Oracle).

#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME WINDOWS#

The next steps are to ensure that the necessary Windows environment variables are defined.

#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME INSTALL#

This will install the ODBC driver on your system: Open a Command Prompt window, and set your current directory to be the instantclient_X_Y directory into which the unzipped files have been copied.The unzipped files will be copied into a subdirectory named instantclient_X_Y, where X and Y represent the version number of the Oracle Database Instant Client (for example, C:\Oracle\instantclient_11_1). Unzip the packages that you have downloaded.Place these packages in a folder or directory on your computer (such as C:\Oracle). You will need the Basic and ODBC Supplement packages.

#ORACLE ODBC DRIVER CONFIGURATION TNS SERVICE NAME DOWNLOAD#

Download the Oracle Database Instant Client from the Oracle web site.To install the Oracle Database Instant Client: Configure a tnsnames.ora configuration file for your client.Set the TNS_ADMIN environment variable.Install the Oracle Database Instant Client and its ODBC driver on your system.To set up the Oracle Database Instant Client, you must: Version 10.2 of the Oracle Database Instant Client does not include all of the required DLL files. Warning! Be sure to use version 11.1 or later of the Oracle Database Instant Client.