You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for ODBC


1 to 20 of 291 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Database Gateway for ODBC User's Guide - Contents

ContentsTechnology 1.3 Oracle Database Gateway for ODBC 1.4 Oracle Database Gateway for ODBC Architecture 1.4.1 … Machine 1.5 ODBC Connectivity Requirements 2 Oracle Database Gateway for ODBC Features and Restrictions … Date Arithmetic A Data Type Conversion A.1 Mapping ODBC Data Types to Oracle Data Types B

Warehouse Builder User's Guide, 11g Release 1 (11.1)

Using Microsoft Products as Sources

Creating an ODBC Data SourceYou must create an ODBC data source to connect to the SQL Server. To do this, you must set up a … System Data Source Name (DSN): Select Start, Control Panel, Administrative Tools, Data Sources (ODBC … ). This opens the ODBC Data Source Administrator dialog box. Navigate to the System DSN tab and click

Services for Microsoft Transaction Server Developer's Guide for Microsoft Windows, 11g Release 1 (11.1)

Programming with Microsoft Transaction Server and an Oracle Database

5.4.2 Using Oracle ODBC DriverThe ODBC Driver Manager distributed with ODBC 3.0 is a Resource Dispenser that supports connection … pooling. Oracle ODBC Driver release 11.1 integrates with the ODBC 3.0 Driver Manager by supporting … the SQLSetConnectAttr(...,..., SQL_ATTR_ENLIST_IN_DTC) call to enlist or de-enlist the ODBC

Database SQL Language Reference, 11g Release 1 (11.1)

Oracle Compliance with SQL/CLI:2003

Oracle Compliance with SQL/CLI:2003The Oracle ODBC driver conforms to SQL/CLI:2003.

Services for Microsoft Transaction Server Developer's Guide for Microsoft Windows, 11g Release 1 (11.1)

Programming with Microsoft Transaction Server and an Oracle Database

5.4.3 Using Microsoft Oracle ODBC DriverAs an alternative to the Oracle ODBC driver, you can use the Microsoft Oracle ODBC Driver. You … benefits of the Oracle ODBC driver, API support for integration, or Oracle client support services … . After enabling the Microsoft Oracle ODBC Driver, perform these additional steps to configure the … Microsoft Oracle

Services for Microsoft Transaction Server Developer's Guide for Microsoft Windows, 11g Release 1 (11.1)

Programming with Microsoft Transaction Server and an Oracle Database

5.4 ODBC Integration with Microsoft Transaction Server OverviewThis section describes how to use Oracle ODBC Driver with Microsoft Transaction Server and a Oracle … Database. No changes to OCI code are necessary for ODBC to operate successfully.

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Generic ConnectivityHeterogeneous Services ODBC agent or a Heterogeneous Services OLE DB agent. Both are included with … your Oracle product as a standard feature. Any data source compatible with the ODBC or OLE DB standards … ODBC or OLE DB driver that can interface with the agent. However, some data access features are only available with transparent

Database Globalization Support Guide, 11g Release 1 (11.1)

Programming with Unicode

ODBC Unicode DatatypesIn ODBC Unicode applications, use SQLWCHAR to store Unicode data. All standard Windows Unicode … ); Microsoft's ODBC 3.5 specification defines three Unicode datatype identifiers for the SQL_C_WCHAR … the ODBC Unicode datatypes for the server against SQL NCHAR datatypes. Table 7-9 Server ODBC Unicode Datatype Mapping

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Introduction

1.5 ODBC Connectivity RequirementsTo use Oracle Database Gateway for ODBC, you must have an ODBC driver installed on the same machine … as the gateway. The ODBC driver manager and driver must meet the following requirements: The … following ODBC catalog functions must work inside a transaction: SQLColumns SQLForeignKeys SQLGetFunctions … On Windows:

Database Readme, 11g Release 1 (11.1)

Oracle® Database Readme

18 Oracle ODBC DriverThe Oracle ODBC Driver Readme file is located at: $ORACLE_HOME/odbc/html/ODBCRelnotesUS.htm

Database Globalization Support Guide, 11g Release 1 (11.1)

Programming with Unicode

ODBC Datatype Oracle DatatypeSQL_WCHAR NCHAR SQL_WVARCHAR NVARCHAR2 SQL_WLONGVARCHAR NCLOB According to ODBC specifications

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for ODBC

Multiple ODBC Data Sources Example: Accessing ODBC Dataare created, you can verify the connection to the new ODBC data sources, as in the following: SQL

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for ODBC

11.6.5 Multiple ODBC Data Sources Example: Accessing ODBC Dataare created, you can verify the connection to the new ODBC data sources, as in the following: SQL

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Initialization Parameters

D.3.10 HS_TIME_ZONEProperty Description Default value for '[+|-]hh:mm' Derived from the NLS_TERRITORY initialization parameter Range of values for '[+|-]hh:mm' Any valid datetime format mask Specifies the default local time zone displacement for the current SQL session. The format mask, [+|-]hh:mm, is specified to indicate the hours and minutes before or after UTC (Coordinated Universal Time—formerly Greenwich Mean

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Initialization Parameters

D.3.16 HS_FDS_SHAREABLE_NAMEto the ODBC driver manager. This is a required parameter, whose format is: HS_FDS_SHAREABLE_NAME … =odbc_installation_path/lib/libodbc.sl Where: odbc_installation_path is the path where the ODBC driver

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.1 Supported SQL StatementsOracle Database Gateway for ODBC supports the following statements, but only if the ODBC driver and

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Data Type Conversion

A Data Type ConversionOracle maps ODBC data types to supported Oracle data types. When the results of a query are … returned, Oracle converts the ODBC data types to Oracle data types. The tables in this appendix show how … Oracle maps ODBC data types to supported Oracle data types when it is retrieving data from a non … -Oracle system. This appendix

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Initialization Parameters

D.2 Oracle Database Gateway for ODBC Initialization ParametersGateway for ODBC. They are as follows: HS_DB_DOMAIN HS_DB_INTERNAL_NAME HS_DB_NAME

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Initialization Parameters

D.3.2 HS_DB_INTERNAL_NAMEProperty Description Default value 01010101 Range of values 1 to 16 hexadecimal characters Specifies a unique hexadecimal number identifying the instance to which the Heterogeneous Services agent is connected. This parameter's value is used as part of a transaction ID when global name services are activated. Specifying a nonunique number can cause problems when two-phase commit recovery actions are

Database Gateway for ODBC User's Guide, 11g Release 1 (11.1)

Initialization Parameters

D.3.5 HS_LANGUAGEProperty Description Default value System-specific Range of values Any valid language name (up to 255 characters) Provides Heterogeneous Services with character set, language, and territory information of the non-Oracle data source. The value must use the following format: language[_territory.character_set] Note: The globalization support initialization parameters affect error messages, the data for