Tuesday, March 20, 2012

An OLE DB error has occurred - Description: "Class not registered"

Hi

I have a package the connection of which is defined in a config file. When the source is on SQLserver, the package executes fine but when i change the connection to Oracle then i am getting this error.

TITLE: Microsoft Visual Studio

Error at DMND_PROBS_EXTRACT [Connection manager "DLWSDV18.PM"]: An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error at DMND_PROBS_EXTRACT [DEMANDPROBLEMDETAILS [1]]: The AcquireConnection method call to the connection manager "DLWSDV18.PM" failed with error code 0xC0202009.


ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)


BUTTONS:

OK

Please let me know if theres any solutions.

Thanks,

Vipul

Do you have the Oracle client tools installed?|||Yes Phil, there was some problem with my oracle install. I re-installed it and it worked.

No comments:

Post a Comment