Los drivers ODBC solo se pueden utilizar con el ODBC .NET Data Provider.
Cita: The "Provider = value " clause is required. However, you cannot use "Provider = MSDASQL" because the OLE DB .NET Data Provider does not support the OLE DB Provider for ODBC (MSDASQL). For access to ODBC data sources, an ODBC .NET Data Provider is available as a separate download at
http://msdn.microsoft.com/downloads. Como podemos ver aquí los proveedores OleDb para ODBC no son compatibles, para poder conectarte tendrian que ser controladores especificos para OleDB y que cumplan con los requerimientos básicos de interfaces del controlador, que son:
Cita: OLE DB Services
-----
IDataInitialize
-----
DataSource IDBInitialize
IDBCreateSession
IDBProperties
IPersist
IDBInfo*
Session
-----
ISessionProperties
IOpenRowset
IDBSchemaRowset*
ITransactionLocal*
IDBCreateCommand*
Command ICommandText
ICommandProperties
ICommandWithParameters*
IAccessor (only required if ICommandWithParameters is supported)
ICommandPrepare*
MultipleResults
-----
IMultipleResults
RowSet
-----
IRowset
IAccessor
IColumnsInfo
IColumnsRowset*
IRowsetInfo (only required if DBTYPE_HCHAPTER is supported)
Row
-----
IRow*
Error
-----
IErrorInfo
IErrorRecords
ISQLErrorInfo*
* indicates an optional interface