Decrease Font Size
Increase Font Size
   BLOG

Cannot initialize the data source object of OLE DB provider Microsoft.Jet.OLEDB.4.0

CREATE THE LINKSERVER FROM Excel

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TestLinkServer" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 41 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TestLinkServer" reported an error. Authentication failed.

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server " TestLinkServer".

If you happen to come across the error mentioned above, here the solution that work for me.

Step to re-produce the problem.

--CREATE THE LINKSERVER FROM Excel
EXEC sp_addlinkedserver

   @server = N'TestLinkServer',
   @provider = N'Microsoft.Jet.OLEDB.4.0',
   @srvproduct = N'Excel',
   @datasrc = N'c:\test\book1.xls',
   @provstr = N'Excel 8.0'
GO

--List all the sheets in the Excel
EXECUTE SP_TABLES_EX 'TestLinkServer'  -- throw the error message

--Solution
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TestLinkServer',
                        @useself=N'False',
                        @locallogin=NULL,
                        @rmtuser=NULL,
                        @rmtpassword=NULL

Comments (6) -

  • online payday loans

    1/8/2010 1:43:50 PM |

    You always pass failure on the way to success.

  • payday loans

    1/12/2010 12:05:35 AM |

    No one has a greater asset for his business than a man's pride in his work.

  • Played Online

    1/29/2010 10:49:18 PM |

    Your post is just the same to the thoughts I was having today. I really appreciate this. Keep going what you're doing.This is an awfully splendid column you've put up there.Nicepost I have acquired a lot of interesting matter that i need.....

  • Watch Pacquiao Vs Clottey Live

    2/15/2010 12:10:12 AM |

    your blog is very imformative and i learn a lot from it.
    Thanks for sharing.

    regards,

    rosela

  • Webthesurfi Rugs Webdesign

    2/15/2010 12:24:02 AM |

    very entertaining and informative blog. Ill be back..

  • Watch Pacquiao Vs Clottey Live

    2/15/2010 12:25:09 AM |

    your blog is very imformative and i learn a lot from it.
    Thanks for sharing.

    regards,

    rosela

Pingbacks and trackbacks (1)+

Add comment

Loading