>In an ADO connection string, what is there any difference between using Provider=SQLOLEDB and Driver=SQL Server?

The first syntax uses OLEDB and the second is an ODBC syntax which uses the OLEDB provider for ODBC.