How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Technology 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
Creating an ODBC Data Source → You 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
5.4.2 Using Oracle ODBC Driver → The 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
Oracle Compliance with SQL/CLI:2003 → The Oracle ODBC driver conforms to SQL/CLI:2003.
5.4.3 Using Microsoft Oracle ODBC Driver → As 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
5.4 ODBC Integration with Microsoft Transaction Server Overview → This 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.
Generic Connectivity → Heterogeneous 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
ODBC Unicode Datatypes → In 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
1.5 ODBC Connectivity Requirements → To 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:
18 Oracle ODBC Driver → The Oracle ODBC Driver Readme file is located at: $ORACLE_HOME/odbc/html/ODBCRelnotesUS.htm
ODBC Datatype Oracle Datatype → SQL_WCHAR NCHAR SQL_WVARCHAR NVARCHAR2 SQL_WLONGVARCHAR NCLOB According to ODBC specifications
Multiple ODBC Data Sources Example: Accessing ODBC Data → are created, you can verify the connection to the new ODBC data sources, as in the following: SQL
11.6.5 Multiple ODBC Data Sources Example: Accessing ODBC Data → are created, you can verify the connection to the new ODBC data sources, as in the following: SQL
D.3.10 HS_TIME_ZONE → Property 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
D.3.16 HS_FDS_SHAREABLE_NAME → to 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
B.1 Supported SQL Statements → Oracle Database Gateway for ODBC supports the following statements, but only if the ODBC driver and
A Data Type Conversion → Oracle 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
D.2 Oracle Database Gateway for ODBC Initialization Parameters → Gateway for ODBC. They are as follows: HS_DB_DOMAIN HS_DB_INTERNAL_NAME HS_DB_NAME
D.3.2 HS_DB_INTERNAL_NAME → Property 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
D.3.5 HS_LANGUAGE → Property 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