473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

DB2 ODBC Error using in DTS (MDAC 2.7)

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.
Jul 20 '05 #1
2 3959
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
Jul 20 '05 #2
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

gastineau5@comcast.net (Zach Gastineau) wrote in message news:<a3883fcb.0404280717.36c3f09f@posting.google. 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
May 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: M P | last post by:
What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB Provider for ODBC Drivers error '80004005' General...
4
by: Kong Li | last post by:
Environments: 1. WinXP SP1, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is 2.573.9030.0), Oracle client 9.2.0.1. 2. Win2000 SP4, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is 2.573.9030.0), Oracle...
5
by: SerGioGio | last post by:
Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection with: - SQL*plus: connection works! -...
2
by: Martijn Rutte | last post by:
Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version...
1
by: Zach Gastineau | last post by:
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...
2
by: J. Marshall Latham | last post by:
I have a simple page trying to enter three pieces of information into a database using ODBC on a web site that has .NET Framework 1.0, so I have to use this Microsoft.Data.Odbc.dll which has been...
1
by: Salad | last post by:
Hi: I am developing an application using FoxPro 2.x tables. My client has AccessXP. AccessXP uses Visual Foxpro ODBC to connect to tables. It does not accept the ISAM Foxpro driver used in A97....
10
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
4
by: paulnamroud | last post by:
Hi guys, I need your help!!!! I have installed and configured a new server called "intranetnew" in order to replace the old server "intranet." With the new server, i'm able to connect to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.