Hi Jerry,
I too had innumerable problems getting Simconnect SP2 and Vista x64 to work together. The problem initially cropped up with a problem loading PMDG's MD11 - FSUIPC was the only addon that didn't have an issue, that would load and display its menu every time. I tried reinstalling Windows & FSX, all to no avail, every time, it seemed, Simconnect would not work (I checked the Event log, and that was full of simconnect.dll not found in the WinSxS folder, despite it being there). I think there is a lot of discussion about whether or not you should even play around with the content of WinSxS - one of the posts at FSInsider suggested that they should not be touched, as it would bork any future reinstall or even clean install.
Anyhow, I finally figured out what the issue was stopping Simconnect.dll. It turns out (and it seemed to be specific to SP2/Acceleration version) that having my \Documents folder anywhere other than the default, C:\users\%username%\Documents would stop it from working - I'd previously kept Documents on a separate partition, pointing the documents folder to that, and for some reason, simconnect doesn't like looking elsewhere other than the default.
Paul Gollnick over at PMDG did say he'd let someone over at ACES know, but I guess with recent news, that bug (if indeed it is a bug), is unlikely to see much happen.
Don't know if that's anything related to your problem, but it may help.
Leo