Download and install the oracle 64 bit driver (v10.2.0 i think) onto your sql server machine.

On your client machine\workstation install the Oracle 10g 32 bit driver (v10.2.0)

This will work as...

Thanks for all the replies ...

We use change controls and sourcesafe to manage changes.

The reason for the question was that I was rolling out the changes and could not see...