Hi All,

I have Asp.net application which I have created on the vista 32 using vs 2005.
Which uses MSDAORA provider to connect to oracle,which works fine.

But when we are deploying on windows 2003 server 64bit it is giving the below error:

Exception: System.InvalidOperationException: The 'MSDAORA.1' provider is not registered on the local machine.

I have search on the google for the solution and found that:

'switch the appication to 32 bit and use a 32 bit Oracle client'

How can I do that ?

or another solution is :
use a 64 bit client and oledb provider instead (Ie, Oracle's provider - ORAOLEDB.ORACLE)

My question is if I installed this provider do I have to uninstall anything or just to install the oracle driver and use

ORAOLEDB.ORACLE and it will work.

Any suggestion very much appriciated.

Thanks
Yanku