IT Forums - Access program with ODP.NET

FredBear

09-06-2003, 07:11 PM

I'm working with an Oracle system, using a .NET program, and using the
ODP.NET library with Oracle Client 9.2.0.1.0 and ODP.NET version
9.2.0.2.102. Everything works fine when I run the class library I developed
on a Windows XP machine as an application or through ASP.NET, but when I run
it on a Windows 2003 Server, I get the following error:

System.DllNotFoundException: Unable to load DLL (OraOps9.dll).
at Oracle.DataAccess.Client.OpsSql.AllocSqlValCtx(OpoSqlValCtx*&
pOpoSqlValCtx)
at Oracle.DataAccess.Client.OracleCommand.Initialize()
at Oracle.DataAccess.Client.OracleCommand..ctor()
at ryangregg.EdPerksIntegration.EdPerkOracleDB.GetFolders()
at UDK.Kansan.Website.EdPerkSetup.ReloadFolderList()

I figured it was probably a permissions problem, and searching the web and
this group seemed to confirm that might be the cause, so I added at first
permissions on the server for the Oracle home directory for just the ASPNET
user and the IUSR_<computer name> account, but still no luck, so I added
Everyone with full control on the Oracle directory (this is just a test
server after all), and still no luck.

Anyone out there have any help/explanation on how to fix this?

Thanks!
Ryan Gregg

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service