Memory error when trying to create a DB2 Connection in SSIS

Posted on 2012-09-08
Last Modified: 2013-08-02

 I'm trying to create a DB2 database connection in SSIS connection manager
 I've selected the "New OLE DB connection" and selected the "IBM OLE DB Provider for DB2". Then i have clicked the "Data Links" button and selected one of the existing connections. When i clicked on "Test Connection", it is throwing the following error message.
Attempted to read or write prortected memory.
This is often an indication that other memory is corrupt.

Open in new window

Can someone kindly help resolve the issue?
Question by:pvsbandi
    LVL 16

    Expert Comment


    Author Comment


     My versions are DB2 UDB 9.7 and SQL Server 2008.
     Your link doesn't apply in my case, as it is not V3.0.

    Accepted Solution

    Looks like the DB2 on my machine is 32 Bit and the Software is 64 Bit and so, are not going together :(

    Author Comment

    Can someone please close this question, as there is no solution to this problem.
     The incompatibility between the 32 bit machine and the 64 bit software is what is causing this issue and i couldn't get any solution to this problem.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now