Windows Oracle Data Access Components (MOSC)

MOSC Banner

OLE DB ERROR

edited Jun 25, 2018 1:57PM in Windows Oracle Data Access Components (MOSC) 4 commentsAnswered
 Hi,

  My Environment :-

       a) Window 2008 - 64 bit
       b) SQL server - 64 bit
       c) Visual Studio 32 bit

   
I've installed both Oracle11g  client ( 32-bit and 64-bit -  Oracle Database 11 g Release 1 Client (11.1.0.7.0)
for Microsoft Windows Server 2008.

Test connection from Visual Studio to remote Oracle DB was successful. When execute the package I've got the following error :

[Connection manager "xxxtcp.sksfrs"] Error: SSIS Error Code DTS_E_OLEDBERROR.

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


Can someone help me on the resolution regarding this problem. Thank you in advance for the reply.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center