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

Hi,

We already solved this issue. The problem appeared to be another import
using the DB2 driver. When, after restarting the SQL Server process, the
linked server to the DB2 database was started/used before the linked server
to Excel, the problem occurred. If the linked server to Excel was first
started/used, everything went fine. IT Support patched the DB2 driver which
solved all problems. Hope this helps.

Kind regards,
Fokko

"carruthers" wrote:

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
.

Relevant Pages

  • Re: Source table filtering in DTS by target table values.
    ... You create the linked server the other way around. ... it is from SQL Server to DB2 ... I doubt that we can create a linked server on an DB2 database ... If ActiveX script can read thorugh A and reject non-relevant rows ...
    (microsoft.public.sqlserver.dts)
  • issue with openquery
    ... I have set up a linked server to DB2 AS/400 as the following: ... and then ran the open query: ... OLE DB error trace [Non-interface error: OLE DB provider unable to process ... But if I directly run the query through the DB2 client on my SQL Server, ...
    (microsoft.public.sqlserver.server)
  • Update
    ... queries against a linked server (DB2 UDB). ... Servers security properties, ... ID and password for the linked server. ... to be that the job owner is a SQL Server login that is not ...
    (microsoft.public.sqlserver.security)
  • RE: Access SQL server from AS/400 DB2
    ... as "Linked Server" in AS/400 DB2. ... Based on my scope, unfortuantely, SQL Server has no such funcationality to ... I will do more research try to find whether IBM DB2 will ... Online Partner Support Specialist ...
    (microsoft.public.sqlserver.connect)
  • Re: DTS Import From AS/400 DB2
    ... DB2 with no success. ... Server or MS Host Integration Server to configure the data source for the OLE ... DB provider. ... I was able to create a linked server using ...
    (microsoft.public.sqlserver.dts)
Loading