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

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."

Who is Participating?
ziolkoConnect With a Mentor Commented:
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

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:

ssosw2Author Commented:
I had done an installation for an HP printer LJ 4345
ssosw2Author Commented:
Server restart got rid of the problem. Still not sure of the cause.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.