what is the best driver for SQL

For a VB front end and a SQL 7 back end what driver is best for the connection string..

there are so many OLE DB choices.

The SQL Server books say use:

Provider= SQLOLEDB
or
Provider = MSDASQL

I’m confused and the text is overwhelming. Can someone break it down for me. I used to use:

Driver=SQL server

thanks