DB2 ODBC Error using in DTS (MDAC 2.7)

[Zach Gastineau]

I'm having problems using the DB2 Connect ODBC Driver in my SQL Server
2000 DTS packages. It started occuring after installing MDAC 2.7
(which is necessary for the .NET framework). This error occurs when I
try to open the transformation that uses an ODBC Connection object
that is pointing to the DB2 ODBC. Has anybody else seen this or has a
solution other than re-installing everything and not loading the .net
framework mdac 2.7. I would like to get the DB2 ODBC driver working
with MDAC 2.7.

[Simon Hayes]

ga********@comcast.net (Zach Gastineau) wrote in message news:<a3**************************@posting.google. com>...

I'm having problems using the DB2 Connect ODBC Driver in my SQL Server
2000 DTS packages. It started occuring after installing MDAC 2.7
(which is necessary for the .NET framework). This error occurs when I
try to open the transformation that uses an ODBC Connection object
that is pointing to the DB2 ODBC. Has anybody else seen this or has a
solution other than re-installing everything and not loading the .net
framework mdac 2.7. I would like to get the DB2 ODBC driver working
with MDAC 2.7.

Can you post a specific error message? It might also be a good idea to
check in a DB2 or IBM forum to see if there are known issues with that
specific version of MDAC. MDAC 2.8 is available, so you could also try
upgrading to see if that resolves your issue, although there's no
specific reference to DB2 in the release notes:

http://support.microsoft.com/default.aspx?kbid=820761

Simon

[bethamsetty]

Hi ,
I also need to access DB2 table in my SQL Server DTS package. but can you give me from where you downloaded DB2 ODBC drivers where I can install and start using DB2 in DTS package.

Regards
Sridhar.B

[e-mail] (Zach Gastineau) wrote in message news:<[e-mail]. com>...[color=blue]
> I'm having problems using the DB2 Connect ODBC Driver in my SQL Server
> 2000 DTS packages. It started occuring after installing MDAC 2.7
> (which is necessary for the .NET framework). This error occurs when I
> try to open the transformation that uses an ODBC Connection object
> that is pointing to the DB2 ODBC. Has anybody else seen this or has a
> solution other than re-installing everything and not loading the .net
> framework mdac 2.7. I would like to get the DB2 ODBC driver working
> with MDAC 2.7.[/color]

Can you post a specific error message? It might also be a good idea to
check in a DB2 or IBM forum to see if there are known issues with that
specific version of MDAC. MDAC 2.8 is available, so you could also try
upgrading to see if that resolves your issue, although there's no
specific reference to DB2 in the release notes:

http://support.microsoft.com/default.aspx?kbid=820761

Simon