i am trying to seek on an index in a SQL 7 database but i am getting an error
message saying the provider is not capable of performing requested operation.

the provider is .Provider = "SQLOLEDB" and i am using ADO 2.5.
Should i be using a different provider?