Requirements for OLE DB Connectivity

Connectivity software requirements depend on the operating system platform and the OLE DB version that you are using.

• Microsoft Data Access Components (MDAC) 2.0 or higher is required. MDAC 2.5 is recommended; the latest version is available for download from <http://www.microsoft.com/data>. MDAC 2.5 can be installed on Windows NT 4.0 and is included in Windows 2000.
• OLE DB supports connectivity to Microsoft SQL Server 7, SQL Server 2000, and Microsoft Access 2000. There are currently two supported OLE DB providers - SQLOLEDB is the supported OLE DB provider for Microsoft SQL Server and Microsoft.Jet.OLEDB.4.0 is the supported OLE DB provider for Access 2000.
• The preferred Net-Library can be set by the SQL Server Client Network Utility. Alternatively, the Net-Library can be specified in the Provider String when making a connection.

Glossary