Microsoft® SQL Server™ provides ODBC drivers and OLE DB providers for performing distributed operations against heterogeneous data sources. SQL Server components that use these drivers and providers include:
The following table summarizes, for each of the major data sources, the driver or provider that has been tested and supplied by Microsoft. Microsoft Technical Support will help you resolve problems you encounter when using these drivers and providers to perform distributed operations. If you are using another driver or provider, contact the vendor of that ODBC driver or OLE DB provider for support.
Data source |
Driver or provider |
DTS |
Replication |
||
---|---|---|---|---|---|
Oracle 8 | Microsoft ODBC for Oracle version 2.573.3401.00 |
S | S | ||
Microsoft OLE DB Provider for Oracle version 2.0010.3401.000 | S | S | |||
Microsoft Jet version 4.0 | Microsoft Jet 4.0 OLE DB Provider version 4.0000.2115.0004 |
S | S | ||
Microsoft Excel spreadsheet | Microsoft Jet 4.0 OLE DB Provider version 4.00.2115.15 |
S | N | ||
Microsoft Jet version 3.51 | Microsoft Access Driver version 4.00.3401.00 | N | S | ||
IBM DB2/MVS | StarSQL 32 version 2.52.0501 | S | S | ||
IBM DB2/AS400 | StarSQL 32 version 2.40.0805* | S | S | ||
S = supported | N = not supported | ||||
* Newer versions of this driver do not support DTS and replication. If version 2.52.0501 is not available, you should install the Microsoft OLE DB/ODBC driver for DB2 that is in Microsoft SNA Server Service Pack 3 or later. |
For the latest information about driver or provider versions, see Readme.txt in the \Mssql7\Install directory.
For more information about replication to heterogeneous data sources, see Implementing Snapshot or Transactional Replication to Heterogeneous Data Sources.
The Informix ODBC driver is not supported for use with Data Transformation Services.
The Intersolv Informix OLE DB provider is supported for DTS imports from Informix, but not DTS exports to Informix. This driver also cannot be used to import metadata.
The Intersolv Informix ODBC driver is supported, but with the following restrictions: