Read about how to register oracle odbc driver, The latest news, videos, and discussion topics about how to register oracle odbc driver from alibabacloud.com
re-register the ODBC driver.
There are several script files under the Windows/system32 directory that can be used to complete the registration of the driver:
odbcconf.exe/s/lv odbcconf.log/f%SYSTEMROOT%/SYSTEM32/MDACCORE.RSPodbcconf.exe/s/lv odbcconf.log/f%SYSTEMROOT%/SYSTEM32/SQLCLNT.RSPodbcconf.exe/s/lv odbcconf.log
[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
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 (
= "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= "
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
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
,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
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
Label:First install ha-instant Client-v11.2.0.3.0-x86.rar : Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x86.rar Ftp://hhdown:[email Protected]/download/ha-instant%20client-v11.2.0.3.0-x64.rar Then perform the installation of ODBC a must choose to install Add environment variable: Tns_admin value:%oracleclient%/network/admin Modify Tnsnames.ora to add the server information that needs to be connected, Note the service_name
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
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
First, the establishment of service name1, select "Net8 Configuration Assistant", select "Local Network Service name configuration."2, choose "Add".3. Select Oracle 8i database or service.4, enter the service name. This is a customized database service name for the remote database, such as "ORCL".5, select network Protocol "TCP".6, enter the host name and port name. such as "DB" and "1521".7, choose whether to test.8, enter the local network service n
Tags: data source ora test installation path admin strong exit Network connectionHow to configure Oracle data source today:1, the need to install Oracle client, if the error check, the anti-virus software all exit and then reinstall;2, after the installation is completed, run ODBCAD32 (64-bit), in the ODBC interface can find the corresponding
found and copied under System32) right-click "cmd.exe" file to run as administrator.Enter "Odbc_install.exe" and click Enter to run, "Oracle ODBC Driver is installed successfully" If successful installation occurs-----------------------------------------------------------------------------------------3. What the environment variables need to configureRight-click
Environment: This machine installs ArcGIS Server10.2,arcgis desktop10.2,64 bit oracle11g and Oracle32 bit client. Direct Connect and service connections are successful.Problem: I want to do the service release, in order to avoid data packaging upload to the server, so I would like to register the database, the registration interface to fill in the following parameters:Then click OK to display the interface as follows:When I click OK again, the server
Label:Project is urgent, need to deliver results in a short time, new team members, the database design is too low, it is difficult to understand the relationship between the database table structure, in order to enable new colleagues to better understand the database table structure, deliberately using PowerDesigner to Oracle, MySQL database reverse generation of physical diagrams, Concept map, hope to bring new colleagues to help, better improve the
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.