richardd (6/9/2011)
Nice article.It makes me wonder why 64-bit SQL can't use 32-bit providers (eg Jet), since the bit-ness of out-of-process COM components doesn't matter. They'd only need a 32-bit host process.
It might be more complicated to set up, but surely it would be easier that the current workaround of putting a 32-bit SQL Express instance in the middle!
That's an interesting question!
You can define a custom surrogate process for a COM component in the registry. I don't know if it can be set to use a 32 bit surrogate, but this thread suggests it can be done. It would be great if you could try and give us some feedback.
-- Gianluca Sartori