Any difference between these 2 providers?
SQLOLEDB
and SQLOLEDB.1?
Printable View
Any difference between these 2 providers?
SQLOLEDB
and SQLOLEDB.1?
Nope. If you open the registry and look at these two keys (and several others) under HKEY_CLASSES_ROOT, you will see they both have the same CLSID.
Basically, an upgrade added the SQLOLEDB.1 clsid and pointed the existing SQLOLEDB to use this new clsid.
Any, existing applications that have provider=sqloledb would then use the newer version.
It is safe to use provider=sqloledb.1 but as far as I know it does not make a difference.
..