I'm having the same problem with a similar configuration:
Windows 7 64 bit
Delphi 2006
I can compile and run with no problem, but the TSession component can't connect during design. I've tried different databases, verified tnsnames, etc. Is the problem caused by the 64 bit OS?