I am migrating to a new fresh PC with windows 7 and getting the above exception "Provider cannot be found. It may not be properly installed" when executing a simple
rc = New ADODB.recordset
Call rc.open(SQL,.....) '====> exception returned
I have checked all the references, MDAC versions etc. It looks fine (anyway, it is a working code from the XP machine).
Note that the code works OK, when called as a linked Excel COM. it returns exceptions only, if executed directly or when debugging.
What could be a problem here? What am I missing?