SQLOLEDB and SQLOLEDB.1

 Some people have asked about the difference between SQLOLEDB and SQLOLEDB.1. The former is the version-independent provider name, while the latter uses a specific version (.1, obviously). It is recommended that, unless you need to use the specific .1 version, you use the version-independent provider name—if for no other reason, to ensure that your connection string works on every machine you port it to (some might not have the .1 update). 

 

[以上答案来自互联网]