Could not initialize data source object of OLE DB provider '%ls'. %ls
This error message indicates that the OLE DB data source object could not be initialized.
This error message can occur because of one of these problems.
| Problem | Resolution |
|---|---|
| One of the initialization parameters specified in sp_addlinkedserver (data_source, location, provider_string, or catalog) is incorrect for this provider. | Verify that these parameters defined for the linked server, specified by executing sp_addlinkedserver, are correct for the given provider. Check the provider’s documentation for the appropriate values for these parameters. |
| Login and password sent to the provider is invalid. | Verify that there is a valid login and password configured for the linked server and the current SQL Server login through sp_addlinkedsrvlogin. |
| Distributed Queries | sp_addlinkedserver |
| Errors 7000 - 7999 | sp_addlinkedsrvlogin |