MDAC 2.6

[bessebo]

I need some help. We are running SQL 7 Service Pack 2 with MDAC 2.5 and I am having some errors when running a DTS Job. It executes properly from DTS within the Designer but errors out with the following error when you run the job from Enterprise Manager, Management, SQLServer Agent, Jobs:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217887 (80040E21) Error string: Multiple-step OLE DB operation generated errors.

I have read on Microsoft sites that to resolve this problem I should upgrade to MDAC 2.6. I have also read that if you are in a SQL7 clustered environment, which we are not, it could break your cluster.

Upgrading to MDAC 2.6 is a concern of ours due to the fact that this is the MDAC that ships with SQL2000 (we have SQL 7). Is there anyone out there that is running MDAC 2.6 with SQL 7 service pack 2? Should I install the MDAC 2.6 RTM or the MDAC 2.6 sp2 refresh.

Any help would be appreciated.

Regards,
Bessebo

 

[JayKusch]

Not sure on your SS7 issue but as a note, MDAC 2.7 is now out and shipping w/ SS2K SP3a.

Thanks

J. Kusch

 

[bessebo]

Yes, I know MDAC 2.7 is out but want to move up incrementally so that I am in line with our clients.

Regards,
Bessebo

 

[SonOfEmidec1100]

MDAC25 - have you tried MDAC25sp2 or 3 this fixed some odd problems for me.

As did sql70 sp3 and sp4 - can you try these ?

good luck.