-->
Mar 14, 2016 - Technology used: Windows 7, UFT 32 bit, Data Source ODBC pointing out to 32 bit C: Windows System32 odbcad32.exe, Oracle client with. Which is free I beleive. At least I've downloaded free linux versions. I am not sure why it is asking for Oracle 7.3.3 client as that version is no.
Important
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.
The Microsoft速 ODBC Driver for Oracle allows you to connect your ODBC-compliant application to an Oracle database. The ODBC Driver for Oracle conforms to the Open Database Connectivity (ODBC) specification described in the ODBC Programmer's Reference. It allows access to PL/SQL packages, XA/DTC integration, and Oracle access from within Internet Information Services (IIS).
Oracle RDBMS is a multiuser relational database management system that runs with various workstation and minicomputer operating systems. IBM-compatible computers running Microsoft Windows can communicate with Oracle database servers over a network. Supported networks include Microsoft LAN Manager, NetWare, VINES, DECnet, and any network that supports TCP/IP.
The ODBC Driver for Oracle enables an application to access data in an Oracle database through the ODBC interface. The driver can access local Oracle databases or it can communicate with the network through SQL*Net. The following diagram details this application and driver architecture.
The ODBC Driver for Oracle complies with API Conformance Level 1 and SQL Conformance Level Core. It also supports some functions in API Conformance Level 2 and most of the grammar in the Core and Extended SQL conformance levels. The driver is ODBC 2.5 compliant and supports 32-bit systems. Oracle 7.3x is supported fully; Oracle8 has limited support. The ODBC Driver for Oracle does not support any of the new Oracle8 data types - Unicode data types, BLOBs, CLOBs, and so on - nor does it support Oracle's new Relational Object Model. For more information about supported data types, see Supported Data Types in this guide.
To access Oracle data, the following components are required:
- The ODBC Driver for Oracle
- An Oracle RDBMS database
- Oracle Client Software
Additionally, for remote connections:
- A network that connects the computers that run the driver and the database. The network must support SQL*Net connections.
Component Documentation
This guide contains detailed information about setting up and configuring the Microsoft ODBC Driver for Oracle and adding programmatic functionality. It also contains technical reference material.
For information regarding specific Oracle product behavior, consult the documentation that accompanies the Oracle product.
For information about setting up or configuring the Microsoft ODBC Driver for Oracle using the ODBC Data Source Administrator, see the ODBC Data Source Administrator documentation.
This section contains the following topics.
Here is the trick,
I wanted to add an ODBC for Oracle in the profiler for an application that is linked(Inter-Isolation communication) with Oracle Client profile, but i had this error ' Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation'.
Anyway, i added a windows 'cmd.exe' to the profile using the streaming profiler. After that i launched the command. By now, i have a command line prompt, which i like!, and i typed 'odbcad32.exe' which is the ODBC configuration window. So, the window pop-up and i added my ODBC without any problem. But i still in the isolated environment not in the profiler. What i did is from the same command window i launched the 'regedit' command, i looked for ODBC and found it in the 'HKEY_CURRENT_USERSoftware'. Then i copied all the created variables in the registry (i didn't want to make an export). After this, i went to the streaming profiler and updated the profile in the registry by using these lines:
Lets assume that 'cosmos' is the name of the data sources and the name of the server.(take look to the picture in the attachment). All you have to do is to create the keys and the variables and their values.
HKEY_CURRENT_USERSoftwareODBCODBC.INI
HKEY_CURRENT_USERSoftwareODBCODBC.INIcosmos
* BufferSize REG_SZ 65535
* Description REG_SZ
* Driver REG_SZ C:WINDOWSsystem32msorcl32.dll
* DSN REG_SZ cosmos
* GuessTheColDef REG_SZ 0
* PWD REG_SZ
* Remarks REG_SZ 0
* SERVER REG_SZ cosmos
* StdDayOfWeek REG_SZ 1
* StripTrailingZero REG_SZ 0
* SynonymColumns REG_SZ 1
* UID REG_SZ
HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources
* cosmos REG_SZ Microsoft ODBC for Oracle
I wanted to add an ODBC for Oracle in the profiler for an application that is linked(Inter-Isolation communication) with Oracle Client profile, but i had this error ' Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation'.
Anyway, i added a windows 'cmd.exe' to the profile using the streaming profiler. After that i launched the command. By now, i have a command line prompt, which i like!, and i typed 'odbcad32.exe' which is the ODBC configuration window. So, the window pop-up and i added my ODBC without any problem. But i still in the isolated environment not in the profiler. What i did is from the same command window i launched the 'regedit' command, i looked for ODBC and found it in the 'HKEY_CURRENT_USERSoftware'. Then i copied all the created variables in the registry (i didn't want to make an export). After this, i went to the streaming profiler and updated the profile in the registry by using these lines:
Lets assume that 'cosmos' is the name of the data sources and the name of the server.(take look to the picture in the attachment). All you have to do is to create the keys and the variables and their values.
HKEY_CURRENT_USERSoftwareODBCODBC.INI
HKEY_CURRENT_USERSoftwareODBCODBC.INIcosmos
* BufferSize REG_SZ 65535
* Description REG_SZ
* Driver REG_SZ C:WINDOWSsystem32msorcl32.dll
* DSN REG_SZ cosmos
* GuessTheColDef REG_SZ 0
* PWD REG_SZ
* Remarks REG_SZ 0
* SERVER REG_SZ cosmos
* StdDayOfWeek REG_SZ 1
* StripTrailingZero REG_SZ 0
* SynonymColumns REG_SZ 1
* UID REG_SZ
HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources
* cosmos REG_SZ Microsoft ODBC for Oracle