Home
IBM Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Lotus® Connectors
Lotus® Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
Lotus® Connectors and Connectivity Guide
Chapter 2 Connectivity
This chapter provides instructions and information for setting up and testing connectivity to the following database systems:
OLE DB Connectivity
This section provides information about setting up connectivity to an OLE DB data source.

OLE DB Connectivity

This section provides information about setting up connectivity to an OLE DB data source.

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. The latest version is available for download from at http://www.microsoft.com.
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.