System Requirements for ADO

ADO and SQL Server

ADO and SQL Server

System Requirements for ADO

To access data in Microsoft® SQL Server™ 2000, you must have the following software installed:

  • Microsoft OLE DB Provider for SQL Server (SQLOLEDB) or Microsoft OLE DB Provider for ODBC (MSDASQL).

  • SQL Server 2000.

  • Network software on the computers on which the driver and instance of SQL Server are installed (not required when connecting to a local desktop instance of SQL Server).
SQL Server

If you use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB), or Microsoft OLE DB Provider for ODBC (MSDASQL) to access data in version 6.0, or 6.5 of SQL Server, you may need to install the catalog stored procedures. For more information, see Upgrading the Catalog Stored Procedures.

Network Software

Network software is required to connect the clients running SQLOLEDB or MSDASQL to the server on which an instance of SQL Server resides. To connect to a server running an instance of SQL Server, you can use the Microsoft Windows® 95, Microsoft Windows 98, Microsoft Windows NT® version 4.0, or Microsoft Windows 2000 operating system, or a compatible network such as Novell NetWare, or Banyan VINES. For information about the hardware and software required for each network, see the documentation for the network.