Re: Error connecting to Oracle by Robin9876
Robin9876
Thu Feb 21 06:12:47 CST 2008
I have got it to work now by using the later Oracle drivers.
On 16 Feb, 01:56, "Mary Chipman [MSFT]" <mc...@online.microsoft.com>
wrote:
> Here's the advice from someone who knows about Oracle:
>
> "Based on the exception message, it sounds like .NET is unable to load
> Oracle's .NET provider rather than being a connectivity issue. I'm
> not sure what would cause that problem, but I'd suggest looking at the
> account and permissions that's running the code. Where is the
> assembly and can that account find it via the File I/O classes?
>
> There was an Oracle release where their client software was installed
> in such a way that non-admins could not see the main client .dll that
> System.Data.OracleClient and Oracle.DataAccess.Client needed to load,
> which caused problems for people running ASP.NET applications because
> the ASP.NET account was non-admin. This issue sounds mildly related.
> It might be worth doing a search using your favorite search engine to
> see if the problem you're seeing is related. If I remember correctly,
> using the following keywords should yield hits on the issue -
> OracleClient "oci.dll" "requires Oracle client" authenticated."
>
> HTH,
> Mary
>
> On Fri, 15 Feb 2008 14:27:43 -0500, "Mary Chipman [MSFT]"
>
> <mc...@online.microsoft.com> wrote:
> >I don't know much about Oracle - let me check into it and I'll get
> >back to you.
>
> >--Mary
>
> >On Wed, 13 Feb 2008 09:09:30 -0800 (PST), Robin9876
> ><robin9...@hotmail.com> wrote:
>
> >>I have since found that there is a slightly different version build
> >>between development and production servers. The development server has
> >>Oracle.DataAccess.dll v9.2.0.700 and the production server has
> >>v9.2.0.401 , would this Oracle dll version have this imapct on the
> >>system if the code has since been compiled and deployed?
>
> >>On 12 Feb, 14:56, "Mary Chipman [MSFT]" <mc...@online.microsoft.com>
> >>wrote:
> >>> Which OracleClient provider are you using? Version of Oracle? I'd do a
> >>> web search to troubleshoot - there's too many possibilities for anyone
> >>> to be able to say off the top of their head.
>
> >>> --Mary
>
> >>> On Fri, 8 Feb 2008 08:37:17 -0800 (PST), Robin9876
>
> >>> <robin9...@hotmail.com> wrote:
> >>> >Using some .Net code to connect to Oracle the follow error message is
> >>> >now being displayed
>
> >>> >File or assembly name Oracle.DataAccess, or one of its dependencies,
> >>> >was not found.
> >>> >Exception Details: System.IO.FileNotFoundException: File or assembly
> >>> >name Oracle.DataAccess, or one of its dependencies, was not found.
>
> >>> >This section of code has not been changed and the a test ODBC
> >>> >connection can be successfully made from the web server. In the
> >>> >Windows path is the folder containing the dll as the first folder
> >>> >location.
>
> >>> >Does anybody know why this error is occurring and how to resolve it?