MDAC version in WinXP SP2

Good morning all,

Strange things are happening on my computer for a while. Let me explain...

I had installed: winXP (without SP2) and VS6 SP6. My program uses ADO to get data from my sql server. I've installed MDAC 2.8. After that, strange things were going to happen.

I am using the .Delete method of a recordset to remove records. After I had installed MDAC that doesn't seem to work anymore.

So, testing and struggling around, I decided to re-install my computer from scratch. WinXP and SP2 installed, VS6 and SP6 installed, also the grid component I use (VSFlexGrid Pro from www.componentone.com). And guess??? Same problem...

Has anyone encountered strange things with MDAC 2.8?

I encountered an issue with interfacing between mdac versions.
What may be happening is that your exe is compiled under 2.7
sp1 and then you upgrade to 2.8. When you try to run the exe, it
is expecting 2.7 sp1. Try recompiling under 2.8 after you explicitly
change the reference in the project from 2.7 sp1 to 2.8 by
deselecting 2.7 saving the project and then adding the reference
to 2.8. Then compile.

HTH

Quote:

---

Originally posted by RobDog888
I encountered an issue with interfacing between mdac versions.
What may be happening is that your exe is compiled under 2.7
sp1 and then you upgrade to 2.8. When you try to run the exe, it
is expecting 2.7 sp1. Try recompiling under 2.8 after you explicitly
change the reference in the project from 2.7 sp1 to 2.8 by
deselecting 2.7 saving the project and then adding the reference
to 2.8. Then compile.

HTH

---

Thanx for that information, but I think I've found the problem. My grid component that I use when compiling my app is not functioning correctly with MDAC 2.8. The older version (the version that is included in my setup set) works well. I didn't see this until now... Hope it helps...

Anyway, thnx for your suggestion

Ok,

so, when you use MDAC 2.8 in combination with the quarter one 2004 update of VSFlexGrid, you run into the named problem. Using the quarter four 2003 version, the problem is gone.

The problem doesn't ly in MDAC, but in the component...

Quarter one 2004 update of VSFlexGrid could have compatibility
settings changed when they compiled it.