Memory error when trying to create a DB2 Connection in SSIS

Posted on 2012-09-08
Medium Priority
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
  • 3
LVL 16

Expert Comment

ID: 38379924

Author Comment

ID: 38386810

 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

pvsbandi earned 0 total points
ID: 38390870
Looks like the DB2 on my machine is 32 Bit and the Software is 64 Bit and so, are not going together :(

Author Comment

ID: 38592353
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

864 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