Then set the environment variable TNS_ADMIN to that directory name. This is the default Oracle client configuration directory for applications linked with this Instant Client.Īlternatively, Oracle client configuration files can be put in another, accessible directory. If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, then create a subdirectory C:\oracle\instantclient_12_2\network\admin.Instant Client 12.1 requires the Visual Studio 2010 redistributable. Instant Client 12.2 requires the Visual Studio 2013 redistributable.
ORACLE ODBC MANAGER INSTALL
Download and install the correct Visual Studio Redistributable from Microsoft.If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path Add this directory to the PATH environment variable.When you execute a query to select data from an Oracle-linked server by using OLE. Configure the ODBC Data Source You must create the ODBC data source for Oracle and add the TNS details for Oracle Connection Manager so that you can import the metadata and preview the data from the PowerCenter Client. I have the odbc driver set up on the server that has the SQL database. Unzip the packages into a single directory such as C:\oracle\instantclient_12_2 Connect to Oracle Using Oracle Connection Manager from PowerCenter Back Next Step 2.All installations require the Basic or Basic Light package. Download the appropriate Instant Client packages for your platform.For example, Oracle Call Interface 18.3 and 12.2 can connect to Oracle Database 11.2 or later. See the Instant Client Home Page for more information about Instant Client packages.Ĭlient-server version interoperability is detailed in Doc ID 207303.1.
0 kommentar(er)
