pinjae.blogg.se - Odbc connection for oracle 10g

#ODBC CONNECTION FOR ORACLE 10G INSTALL#
#ODBC CONNECTION FOR ORACLE 10G UPDATE#
#ODBC CONNECTION FOR ORACLE 10G DRIVER#
#ODBC CONNECTION FOR ORACLE 10G FULL#

Lightning Filters – Filter Web Part for SharePoint.Data Viewer – External Data Reporting and Charts.Lightning List Actions – Build Command Bar Actions.Lightning Conductor – SharePoint and Graph Content Aggregation.Business Connectivity Services SAP Connector.

BCS Meta Man for SharePoint Business Connectivity Services.

SharePoint Chart – Contextual 3D or 2D Charts.

Social Squared – Enterprise Discussion Forum.

Data Viewer Web Part – External Data Visualization.

Lightning Forms – SharePoint List Form Designer.

DeliverPoint – SharePoint Permission Reporting and Management.

Lightning Conductor – Cross Site Collection List Rollup.

When prompted, enter the database login credentials.Ĭlick OK to complete the process. This name will be that which you named in the TNSNAMES.ora file’s Alias = section.Ĭlick ‘Test Connection’ to ensure your settings are all correct. Note: you should be able to select the TNS Service Name from the drop down list.

#ODBC CONNECTION FOR ORACLE 10G DRIVER#

In the ‘Oracle ODBC Driver Configuration’ dialog, enter the details of your data source. In the ‘Create New Data Source’ dialog, select the ‘Oracle in OraClient 11g_home1’ driver. In the ‘User DSN’ tab of the ‘ODBC Data Source Administrator’ dialog, click Add. In the Windows Start menu, click on the Data Sources (ODBC) icon that was created by the ODAC client install. Note: the ‘SQLNET.ora’ generally doesn’t need to be changed. Open the ‘TNSNAMES.ora’ file in Notepad and enter your Oracle database details in the file. Where ‘johndoe’ is the windows user name.Ĭopy these two files into the ‘Admin’ directory above. This is typically:Ĭ:\app\johndoe\product\11.2.0\client_1\Network\Admin\Sample Locate the SQLNET.ora and TNSNAMES.ora in the ‘samples’ directory of the newly installed Oracle client home directory. Step 2 – Setup the SQLNET and TNSNAMES files This concludes the steps for installing the ODBC drivers. When the installation is complete, click ‘Exit’.

#ODBC CONNECTION FOR ORACLE 10G INSTALL#

In the ‘Summary’ dialog, verify that the components you have selected for install include the ‘Oracle ODBC Driver for Instant Client 11.2.0.3.0’. In the ‘Available Product Components’ dialog, go with the default options. In the ‘Install Location’ dialog, enter a path to install the ODAC home directory to in the ‘Oracle Base:’ field. In the ‘Select a Product to Install’ dialog, go with the default ‘Oracle Data Access Components for Oracle Client 11.2.0.3.0’ option. In the ‘Oracle Universal Installer’, click the Next button. Locate the Setup.exe file under the root directory of the extracted zip file’s directories. Unzip the file to a location of your choosing.

#ODBC CONNECTION FOR ORACLE 10G FULL#

You can install the full administrative option of the Oracle Client to obtain the ODBC driver.ĭownload the ODAC112030_圆4.zip file from Oracle’s web site: In this example we will be installing the ODAC client to complete an ODBC setup on a Windows 7 (64-bit) operating system. Step 1 – Install the ODAC or Oracle Client These are required by the Oracle Universal Installer to run the ODAC installation program.

#ODBC CONNECTION FOR ORACLE 10G UPDATE#

Prerequisites: Java JRE or SDK 6 Update 27 or later. The following blog shows the process involved for each of these steps to get you a working connection to an Oracle database.

Use the ODBC Data Source configuration tools to create the ODBC Data Source.

Setup the SQLNET and TNSNAMES files in the Client or ODAC home’s Admin directory.

Install the ODAC (Oracle Data Access Components) or Oracle Client on the Workstation or Application Server.

This article explains the steps including tnsnames.ora configuration.Ĭonnecting to an Oracle database via and ODBC driver requires the following steps: Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup.