ODBC and OLE DB providers have been deprecated in Data Management and may not be supported in future versions.
Connects to arbitrary OLE DB or ODBC databases.
-
Generic OLEDB (oledb): use this for OLE DB providers that are not explicitly supported by Data Management. Requires selection of Provider name and manual entry of connection parameters.
-
ODBC Native Generic (odbc_native): useful when you have a driver that is not supported by any other database provider. Available ODBC drivers are displayed on a list. When you select a driver, Data Management will attempt to query the driver for connection parameters. Only some drivers support this functionality.
-
ODBC Native DSN (odbc_native): useful when you have a driver that is not supported by any other database provider. Requires selection of DSN and manual entry of connection parameters.