Client112.jpg' alt='Install Oracle Instant Client On Windows 7 64 Bit' title='Install Oracle Instant Client On Windows 7 64 Bit' />Setting up an Oracle ODBC Driver and Data Source.Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup.This article explains the steps including tnsnames.Connecting to an Oracle database via and ODBC driver requires the following steps Install the ODAC Oracle Data Access Components or Oracle Client on the Workstation or Application Server.Setup the SQLNET and TNSNAMES files in the Client or ODAC homes Admin directory.Use the ODBC Data Source configuration tools to create the ODBC Data Source.The following blog shows the process involved for each of these steps to get you a working connection to an Oracle database.Prerequisites Java JRE or SDK 6 Update 2.These are required by the Oracle Universal Installer to run the ODAC installation program.Oracle Instant Client enables applications to connect to a local or remote Oracle Database for development and production deployment.The Instant Client libraries.Download the free trial version below to get started.Doubleclick the downloaded file to install the software.Step 1 Install the ODAC or Oracle Client.In this example we will be installing the ODAC client to complete an ODBC setup on a Windows 7 6.You can install the full administrative option of the Oracle Client to obtain the ODBC driver.Download the ODAC1.Oracles web site http www.Unzip the file to a location of your choosing.Locate the Setup.Install Oracle Instant Client On Windows 7 64 Bit' title='Install Oracle Instant Client On Windows 7 64 Bit' />Author Topic What Oracle client for a 10.Install on Windows Server 2012 64bit Read 14301 times.Double click to run the setup program.In the Oracle Universal Installer, click the Next button.In the Select a Product to Install dialog, go with the default Oracle Data Access Components for Oracle Client 1.In the Install Location dialog, enter a path to install the ODAC home directory to in the Oracle Base field.In the Available Product Components dialog, go with the default options.In the Summary dialog, verify that the components you have selected for install include the Oracle ODBC Driver for Instant Client 1.Click Install.When the installation is complete, click Exit.This concludes the steps for installing the ODBC drivers.Step 2 Setup the SQLNET and TNSNAMES files.Locate the SQLNET.TNSNAMES.Oracle client home directory.This is typically C appjohndoeproduct1.NetworkAdminSample.Where johndoe is the windows user name.Copy these two files into the Admin directory above.Open the TNSNAMES.Notepad and enter your Oracle database details in the file.Save your changes.Note the SQLNET.Step 3 Create the ODBC Data Source.In the Windows Start menu, click on the Data Sources ODBC icon that was created by the ODAC client install.In the User DSN tab of the ODBC Data Source Administrator dialog, click Add.In the Create New Data Source dialog, select the Oracle in Ora.Client 1.Click Finish. In the Oracle ODBC Driver Configuration dialog, enter the details of your data source.Note you should be able to select the TNS Service Name from the drop down list.This name will be that which you named in the TNSNAMES.Alias section.Click Test Connection to ensure your settings are all correct.When prompted, enter the database login credentials.Click OK.Click OK to complete the process.Folks who read this article also enjoyed Primavera P6 Database Connection Configuration Details.How To Install A New Instance Of Microsoft SQL Server 2.Express.SQLServer.Exception The TCPIP connection to the host, port 1.PHP Installation Manual.Re. License Serial Number Nch Software Express . Compiling PHP4 to have oracle 8 support oci.Debian Linux, using the Oracle 1.Log in as root.PACKAGES REQUIRED.OTHER PACKAGE REQUIREMENTS.Download Game Facebook Di Android Apps on this page.Oracle Client Libraries i used Oracle 1.Server, but you should be able to use, as has been previously said, any set of the oracle client libraries from 8i onwards.ENVIRONMENT REQUIREMENTS.ORACLEHOMEwhere u installed the oracle client.LDLIBRARYPATHLDLIBRARYPATH ORACLEHOMElib.LDPRELOADlibclntsh.ORACLEHOMElib to the list of paths.RDBMS is my ORACLEHOME.PHP4 Version.PHP4 Version php.Find section labeled COMMONCONFIG.ORACLEHOME, LDPRELOAD and LDLIBRARYPATH.IF YOU GET.ORACLEHOMElib path is in there, and has been reloaded with ldconfig.OSs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |