SQL Server: OLE DB (ADO) Data Provider

  1. SQL Server clients must use the following data-source provider:

  2. Select the Microsoft OLE DB Provider for SQL Server from the list:

    OLE

  3. Enter the connection information necessary to log onto the data source.

  4. Go to Database>>Set Datasource Location to confirm that the data-source provider was selected properly. Expand the database tree and review the properties. They should look something like this: