I have a server running Windows Server 2003 64-bit edition. I have a 32-bit version of the Oracle 10g client installed (apparently my 32-bit app will not run correctly with the 64-bit version installed).
I have a VBS script that uses the MSDAORA provider to connect to the database; it worked on a 32-bit server but gives "Provider cannot be found" when run on the 64-bit server.
I see that the MSDAORA is listed in the WOW part of the registry but not the main part (as I would expect considering a 64-bit Oracle is not installed). Is there a way to make my VBS script look for 32-bit providers using WOW?