pvsbandi
asked on
Memory error when trying to create a DB2 Connection in SSIS
Hi,
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.
Can someone kindly help resolve the issue?
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.
Can someone kindly help resolve the issue?
ASKER
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
http://blogs.msdn.com/b/sjackson/archive/2010/06/11/microsoft-ole-db-provider-for-db2-v3-0-is-available.aspx
hth
Mike