that requires access to the Oracle database on the server, which can be the same machine as the servers, or any other computer on which the network can access the server.The following discusses how to configure Oracle 9i ODBC on a Windows client computer to access a remote Oracle 9i database.The principle of access to
[Translated from mos] list of well-known ODBC drivers for accessing Oracle Database
Source:List of Well Known ODBC Drivers For Accessing An Oracle Database (Document ID 1932774.1)
Applicable:Oracle ODBC Driver-Version 8.0.5.1 and
Administrator can see the ODBC driver entry: 3. Select the ODBC configuration DSN, for example, can be based on the actual situation of the world Oracle ODBC Driver configuration. Click Test Connection to enter a password
This document describes how to configure odbc to connect to the local oracle database by performing the following steps: 1. Enable the remote oracle database service. 2. On the local client, install the oracle database (the version is win32_11gr2_client, mainly to install the oracl
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R
= "dsn=155oracle; Uid=zhangwei; Pwd=zhangwei "/> So you can access the database, but, I say, but why do I not set up the data source it! You want to ah, the user to access your database to set up a local ODBC data source, obviously this is not the right way, of course, this is also good, can be used as testing, but not for production purposes. So how do we write the connection string in the production environment, as follows: key= "
First, if the Oracle database is installed, this is roughly the directory:D:\oracle\product\11.2.0\client_1\oui\jlib\classes12.jar orD:\oracle\product\11.2.0\dbhome_1\oui\jlib\classes12.jarAttention:For Oracle11 Jdbc\lib There is no Classer12.jar file (Note: I installed in the Windows8 11g, this file is present, import
Oracle connects to the odbc data source, oracleodbc
Connect Oracle to odbc Data Source
Description
There are two ways to connect oracle to the ODBC Data source: hsodbc and dg4odbc. In short, dg4odbc is an upgrade of hsodbc. The tw
,ezconnect)4)Export Oracle_home=/usr/lib/oracle/11.2/client64Export ld_library_path= $ORACLE _home/lib:/usr/lib64: $LD _library_pathExport tns_admin= $ORACLE _home/network/adminExport path= $PATH: $ORACLE _home/bin: $HOME/bin5)And at once we do such check:# ldd/usr/lib/oracle
Environment: Windows 7, 32-bit operating system1. Download the driver packageThe Oracle website is available for download.Base pack: Instantclient-basic-win32-10.2.0.4.zipODBC Package: Instantclient-odbc-win32-10.2.0.4.zipTwo packages must be in the same version.2. Unzip the installationUnzip the above two packages, put the extracted files in the same directory (
Windows Oracle ODBC installation and configuration
Environment: Windows 7, 32-bit OS1. Download the driver package
The official Oracle website can be downloaded.Base package: instantclient-basic-win32-10.2.0.4.zipOdbc package: instantclient-odbc-win32-10.2.0.4.zip
The ver
Tags: qlikview ODBC SQL ServerOne, Qlikview configures ODBC connection to SQL SERVER1. Open ODBC Data Source Administrator: Run--〉ODBC2, add User DSN3, select SQL Server Native Client 11.0, then click [Finish]4. Enter the user name and password for the connection database5, select the default connected database (you can not set this step)6, Configuration complete
This document is about the SPSS statistics 19.0 How to configure an ODBC connection to a local Oracle database, as follows:1, open the remote Oracle Database service, open the following two2, in the local client, the installation of the Oracle database (version win32_11gr2_client, mainly to install the
.
Online Application Upgrades
Hot Patches--installation upgrades or patches do not need to restart the database.
Database Repair Recommendations
The DBA can be guided during error diagnosis and solution implementation.
Logical Object Partitioning
Logical objects can be partitioned, and partitions can be created automatically to facilitate the management of large databases (Very Large Databases VLDBs).
New High-performance LOB Infrastructure
The new PHP
Using the JDBC-ODBC bridge to connect to the Oracle database and JDBC driver is almost the same, so we don't have to set the environment variable. There are two key statements for connecting to the database in JDBC:
Class. forname ("oracle. JDBC. Driver. oracledriver ");Co
Label:Previously reprinted an article installed on Windows, I actually installed on the CentOS. The following are the installation records: First, operating system environment II. database environment (log in with Oracle user) Third, DG4ODBC In Oracle DB 11g, Oracle Data Gateway is installed with the database by defa
Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the handling process records.First, extract the installation package and generate a client directory. When runInstaller is run, an error is reported. The error is as
Recently, we helped customers configure the odbc transparent gateway to access IPVs db in oracle through DB link.A simple record:(1) configuration of listener. ora and tnsnames. ora:[Wsj81 @ localhost admin] $ cat listener. ora# Listener. ora Network Configuration File:/wsj/oracle/app/product/11.2.0/dbhome_1/network/admin/listener. ora# Generated by
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.