This content has been marked as final. Show 5 replies
Regarding to document you have one of these solutions :
ODBC agent for accessing ODBC data providers
OLE DB agent for accessing OLE DB data providers that support SQL processing--sometimes referred to as OLE DB (SQL)
OLE DB agent for accessing OLE DB data providers without SQL processing support--sometimes referred to as OLE DB (FS)
To avoid any confusion I will clarify that Generic Connectivity is available in 11g as the product Database Gateway for ODBC (DG4ODBC). This a direct replacement for the 10g generic connectiivty products, such as HSODBC. However, what is no longer available in 11g is HSOLEDB and only ODBC connectiivty is available using the gateway products but not OLEDB.
The Oracle OLEDB provider is still available and the following note may help -
Master Note For The Oracle Provider for OLE DB (OLE DB) (Doc ID 1132946.1)