My environment - MOSS 2007 Enterprise CAL , SQL Server 2008, Windows
server 2008 (all 1 box).

I have created a set of tables / views in SQL Server. I can see this
data using Management Studio, and from Excel. I cannot get SPD to
"show data" in manage connections (I am trying to create a dataview).
My SPD is 32 bit on the client. (I understand there is not a 64 bit
SPD to deploy to the server). Is there a problem connecting MOSS to
the datasource? Is there a problem with an OLE DB driver for 64 bit
office applications (as I read in an SQL Server post?) ANy thoughts at
all? I have created many linked data sources like this on 32 bit
deployments.

THanks in advance for your assistance. No I dont want to by some
custom packed software to do somemthing like this.