Connecting to IBM DB2 USING SSIS

We need to connect to an DB2 server using ODBC provider, so we tried with the folowing:

Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;

But when we try to connect using the above connection string we get teh following error:

"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.

Thanks in advance.

What source did you use?

If you set up an ODBC entry in Windows, you can use a DataReader Source to go against that ODBC entry.

|||

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

|||

Murugan S wrote:

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

Then this doesn't sound like an SSIS problem. Perhaps the driver isn't installed correctly or is corrupt. Have you tried reinstalling the DB2 client?

|||

I have been trying different connection methods for some time trying to make SSIS "play nicely" with DB2 and unfortunately have not found a solution yet.

If someone out there has had success in doing so it would be very much appreciated if you could share the methodology and specific components you used to successfully retrieve data.

We're still using DTS on 2000 to export our IBM related data to SQL.

TR

|||

What type of connection are you using in DTS?

|||

in DTS I'm simply using an "Other Connection" and specifying the DSN that is connecting using the IBM Client Access Driver.

tr