Solved

Could not create an instance of OLE DB  SQL Schedule job fails

Posted on 2007-03-21
5
1,139 Views
Last Modified: 2011-09-20
Hi,
There is a scheduled job on our SQL server that processes in 8 steps. The first step is to copy Excel files from  a template folder to populate it with the particular days date. The  rest of the step invoke stored procedures . The joba wwere running ok until yesterday when the first step is successful and the rest fail.
The error for the failed steps is
"Executed as user: NT AUTHORITY\SYSTEM. Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [SQLSTATE 42000] (Error 7302)  OLE DB error trace [Non-interface error:  CoCreate of DSO for Microsoft.Jet.OLEDB.4.0 returned 0x80040154]. [SQLSTATE 01000] (Error 7300).  The step failed."

0
Comment
Question by:ssosw2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 21

Expert Comment

by:ziolko
ID: 18762597
0x80040154 is: Class not registered did you install/uninstall any software??

easiest way might be reinstalling MDAC components (just make sure you install correect one with jet engine) but check with MDAChecker before avali. here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

ziolko.
0
 

Author Comment

by:ssosw2
ID: 18762737
I had done an installation for an HP printer LJ 4345
0
 
LVL 21

Accepted Solution

by:
ziolko earned 500 total points
ID: 18762755
Class not registered means that some COM DLL is missing or is not registered, i don't think that printer driver would spoil OLE DB but you never know.

check MDAC version and re-install it if needed

ziolko.
0
 

Author Comment

by:ssosw2
ID: 18834547
Server restart got rid of the problem. Still not sure of the cause.
0
 

Expert Comment

by:WPSLNetops
ID: 21230662
I have the same problem in SQL2000 cluster , each time it happens I have to fail over to another node and problem goes away, but it come back again after few day!!

any solution other than re-start will be greatly appriciated.
Thanks


0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question