I have a program compiled in windows 7 which keeps delivering the Runtime 430 automation error when executing it on XP and older OS's. This error is known to be related to the incorrect MDAC version. If I compile this same program, with the same options, on an XP box, this error does not occur.

From what I understand Windows 7 uses WDAC while XP and older use MDAC.

So how do we use ado.db connections for SQL in windows 7 while being able to compile the program so the exe will correctly function in windows XP?

Thanks