My project it using VB6 and ADO. When I compile the project on Windows 7 machine, the generated application (.exe file) is working well on other Windows 7 machine. But then error when its running on Windows XP machine.
Solution: download Windows6.1-KB2640696-v3-x86.msu from microsoft website. Then install this update package on developer machine (on my Windows 7 machine) and recompile the project
reference: https://support.microsoft.com/en-us/kb/2640696