This content has been marked as final. Show 5 replies
Thanks, but the Generic Connectivity is not supported by Oracle 11g is there any other way?
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)
The document is for Oracle 10g and this functionality is not present anymore in Oracle 11g
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)