ODP.NET

We have developed a desktop (exe) application in VB.net using Visual Studio 2005. We are using ODP.net version 11.1.0 to connect to an Oracle 10g Server. Our application works fine on our development machines. We can connect to the database, run queries etc. We are specifying the server by TCP/IP address in the connection string (I've read somewhere that this is called Direct Mode).

However, we are inexperienced at deploying applications that use Oracle components and don't know what to include in our deployment?

We are using Microsoft's ClickOnce to deploy our application. By default Visual Studio suggests that we should just include Oracle.DataAccess.dll in our deployment folder (our version is 2.111.6.20). Is this correct? Are there other files that we should include in our deployment? When we deploy this way, what are the prerequisites that must be installed on the deployment computer for our application to work? We've been instructing users to download and install the ODTwithODAC1110620 package from Oracle. This seems to work sometimes, but other times it only works on computers that already have the full Oracle client (OCI) installed. When it doesn't work users get the message "'The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception."

We're hopelessly lost after hours or Google and forum searching. Please be as verbose as possible in your response.

Thanks in advance!

Philip