ADO.NET Support Notes
The following table lists known ADO.NET database drivers that are currently not supported or have limited support in DatabaseSpy.
Database | Driver | Support notes |
|---|---|---|
All databases | .Net Framework Data Provider for ODBC | Limited support. Known issues exist with Microsoft Access connections. It is recommended to use ODBC direct connections instead. |
.Net Framework Data Provider for OleDb | Limited support. Known issues exist with Microsoft Access connections. It is recommended to use ADO direct connections instead. | |
Firebird | Firebird ADO.NET Data Provider | Limited support. It is recommended to use ODBC or JDBC instead. |
Informix | IBM Informix Data Provider for .NET Framework 4.0 | Not supported. Use DB2 Data Server Provider instead. |
IBM DB2 for i (iSeries) | .Net Framework Data Provider for i5/OS | Not supported. Use .Net Framework Data Provider for IBM i instead, installed as part of the IBM i Access Client Solutions - Windows Application Package. |
Oracle | .Net Framework Data Provider for Oracle | Limited support. Although this driver is provided with the .NET Framework, its usage is discouraged by Microsoft, because it is deprecated. |
PostgreSQL | - | No ADO.NET drivers for this vendor are supported. Use a native connection instead. |
Sybase | - | No ADO.NET drivers for this vendor are supported. |