When I try to connect I get the following message:

ADODB.Connection error '800a0e7a'

ADO could not find the specified provider.

This is the provider that I am using Provider=MSDASQL.1
I am trying to connect to an Access 97 database.

Does anyone have any clues?