RE: Cannot initialize the data source object of OLE DB provider ...

I am also having this issue.

"Fokko" wrote:

Hello,

I am having troubles connecting to Excel using Linked Servers. Most of the
times it works really fine, but sometimes there is something being messed up.
After that I cannot access Linked Servers to Excel anymore. When I restart
the sql server process everything works fine again.

The error I get is: Cannot initialize the data source object of OLE DB
provider "Microsoft.Jet.OLEDB.4.0" for linked server "ImportServer_71".
(Error number: 7303).
After some checking, testing and thinking the following situation is the
problem; on the same server, linked servers to IBM DB2 exist which are being
accessed through the MSDASQL driver.
If, after a restart of the SQL Server process, the IBM DB2 linked server is
being accessed first, the Excel linked servers are not available anymore. If,
after a restart of the SQL Server process, the Excel linked server is being
accessed first, everything works fine.

Anyone ideas?

Kind regards,
Fokko
.