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 … Mapping ODBC Data Types to Oracle Data Types B Supported SQL Syntax and Functions B.1 Supported
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
Creating an ODBC Module → After you set up the ODBC connectivity to a data source, you must create an ODBC module to import … the metadata from this data source. The ODBC node is available under the Databases node in the … Projects Navigator. To create an ODBC module: Right-click ODBC and select New ODBC Module.
Setting up ODBC Connectivity → While ODBC connectivity is widely available, it is most commonly used to connect to data sources on … connecting to any ODBC source. ODBC setup on the source system can vary greatly in different … environments. The following discussion describes the common case of setting up ODBC connectivity to a source … documentation
Connecting Through ODBC → Oracle Warehouse Builder can leverage support for ODBC provided by the Oracle Database to integrate … with any data source that supports ODBC connectivity. ODBC provides a generic connectivity that is … specific ODBC or object linking and embedding (OLE) database drivers installed on the client … connecting to
Creating an ODBC Data Source → You must create an ODBC data source to connect to the SQL Server database using ODBC. You must set … (ODBC). This opens the ODBC Data Source Administrator dialog box. Navigate to the System DSN tab and
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
Oracle Compliance with SQL/CLI:2008 → The Oracle ODBC driver conforms to SQL/CLI:2008.
Connecting to SQL Server Database Through ODBC → the ways to connect to an SQL Server database from Oracle Warehouse Builder is to use an ODBC gateway … import metadata, refer to the following sections: \"Creating an ODBC Data Source\" \"Configuring the
Connecting to Excel Spreadsheets Through ODBC → Scenario A company stores its employee data in an Excel file called employees.xls. This file contains two worksheets: employee_details and job_history. You must load the data from the employee_details worksheet into a target table in Oracle Warehouse Builder. Solution To load data stored in an Excel file into a target table, you must first use the Excel file as a source. Oracle Warehouse Builder enables
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.
Connecting to an ODBC Data Source → Oracle Warehouse Builder can access any data source that supports open database connectivity (ODBC … ). This is possible using the ODBC support provided by Oracle Database. You can use ODBC access for
5 Connecting to Microsoft Data Sources Through ODBC Connection → This chapter provides examples of using ODBC connectivity to connect to Microsoft Excel and … Through ODBC\" \"Connecting to SQL Server Database Through ODBC\"
ODBC installation → The ODBC SDK redistributable components are installed in C:\\Windows\\System32 on Windows systems … . Microsoft only permits TimesTen to redistribute portions of the ODBC SDK; those portions are … ODBC SDK, which can be installed separately as required. Additionally, the ODBC C language header … files and ODBC
6.7 ODBC → The ODBC SQLExtendedFetch function appears in TimesTen header files. However, TimesTen does not support this function.
ODBC Administrator → The ODBC Administrator is a utility program used on Windows to create, configure and delete data
Troubleshooting → Connectivity Using ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default … Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SA'. (SQL State
Troubleshooting → Figure 5-1 ODBC Microsoft Excel Setup Dialog Box Description of \"Figure 5-1 ODBC Microsoft Excel … initialization parameter file. FALSE is the default setting for this parameter. Step 6: Create an ODBC … Source Module Use the following steps to create an ODBC source module: From the Projects Navigator … , create
Case Study → Warehouse Builder. Step 1: Install ODBC Driver for Excel To read data from Microsoft Excel, you need the … ODBC driver for Excel. By default, the ODBC driver for Excel is installed on a Windows system. Step … Microsoft ODBC Administrator. Select Start, Settings, Control Panel, Administrative Tools, Data … Sources
Adding the SQL Server as a Source in Oracle Warehouse Builder → The final step involves adding an ODBC module in Oracle Warehouse Builder, and importing the data … from the SQL server into this module. To add an ODBC source module in Oracle Warehouse Builder … : Within a project in the Projects Navigator, navigate to the Databases node. Right-click ODBC and select … New ODBC