My project uses a provider insensitive ado I wrote using System.Data.Common.  When I access the website on my local machine, everything runs fine.  If a user tries to access the website hosted on my machine, they get an error.

First, it was System.Exception : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

So, I added System.Data.OracleClient to the references and set copy local to true.

Then, they got this error

System.Data.OracleClient.OracleException : Error while trying to retrieve text for error ORA-12154

Some reserch showed me this may be related to TNS names.  Why should it matter what the client has for oracle when the code is on my local (and works when run locally)?  Any ideas on how to fix this problem?  It doesn't error at all for the Microsoft SQL Server 2005 databases that I am using.

Because I am using Windows authentication for my website (and I have <deny users="?" />) I had to grant read access to the "everyone" group on my oracle folder and all children.

The better way to fix this stems from an issue where the default settings when installing the oracle client do not allow for the windows authentication I was using.  I granted read access to the oracle folder and all sub folders to the authenticated users group.  This fixed the problem.