Dll Problem

do refere below links

https://stackoverflow.com/questions/15596834/could-not-load-file-or-assembly-oracle-dataaccess-or-one-of-its-dependencies

https://stackoverflow.com/questions/15293975/could-not-load-file-or-assembly-oracle-dataaccess-error

Try Adding a tag to your application web.config.
 

Thanks

You do not say what type of DLL you are trying to use, whether managed or unmanaged. You do not say if your application is managed or unmanaged.

I assume you are using C#, therefore your applicaiton is managed. I think but I am not sure that the error message you are getting is the result of attempting to use an unmanaged DLL. You can do that but it is better to use a managed DLL when available. To use an unmanaged DLL I think you need to register it as in:

Installation Guide
https://docs.oracle.com/en/industries/health-sciences/inform/7.0/install/index.html?toc.htm?226725.htm

However see the following for Nuget packages with managed libraries.

Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database
https://www.oracle.com/database/technologies/net-downloads.html
 

Hello Pratik,

 

When encountering a "Could not load file or assembly" error in ASP.NET, it typically indicates a problem with the referenced assembly or one of its dependencies. In this case, the error is specifically related to the Oracle.DataAccess assembly.

To troubleshoot this issue, you can follow these steps:

1. Verify the Oracle.DataAccess assembly: Ensure that the Oracle.DataAccess assembly is present in the correct location and it is the correct version for your application. You may need to reinstall or update the Oracle.DataAccess assembly if it is missing or outdated.

2. Check the dependencies: The error message suggests that one of the dependencies of the Oracle.DataAccess assembly may be causing the issue. Use a tool like Dependency Walker to analyze the dependencies of the Oracle.DataAccess assembly and ensure that all required dependencies are present and correctly configured.

3. Check the application's target platform: The "incorrect format" error can occur if the application is targeting the wrong platform (e.g., 32-bit vs. 64-bit). Ensure that the application's target platform matches the platform of the Oracle.DataAccess assembly and its dependencies.

4. Check the application pool settings: If you are hosting your ASP.NET application in IIS, ensure that the application pool is configured correctly. Set the "Enable 32-Bit Applications" option to the appropriate value based on the platform of the Oracle.DataAccess assembly and its dependencies.

5. Check the machine.config file: The machine. config file located in the .NET Framework installation directory can sometimes contain conflicting assembly binding settings. Review the machine.config file and remove any conflicting settings related to the Oracle.DataAccess assembly.

By following these troubleshooting steps, you should be able to resolve the "Could not load file or assembly" error related to the Oracle.DataAccess assembly in your ASP.NET application.

Hello Pratik,

Please check oracle data provider reference, step need to check to resolve this issue.

1.  Install the Correct Oracle Data Provider:
2. Update Configuration Files: check referece version in config, ethier appsetting.json or web.config
3. Recompile and Rebuild:
4. Update Oracle Client: Ensure that your Oracle client is up-to-date. Sometimes, updating the Oracle client can resolve compatibility issues.