Which version of Oracle 10g to use for ASP.NET v2.0?

I have had some problems recently with my versions of Oracle 10g. The webserver
was unable to use the appropriate Oracle client dlls on the webserver machine to
communicate to the Oracle database on a separate server. The webserver machine
has now been wiped clean and I am about to install Oracle 10g. However, in order
to avoid the problem again - does anybody have a definitive answer as to the
correct version (release) of Oracle 10g that should be used so that I do not
need to start loading patches etc to make it work with ASP.NET v2.0?

Many thanks...

I find it strange that you had problems with the Oracle client dlls. I have been
using Oracle 8i client with 10g server without any problem. I have also used
Oracle 10g client with 10g Server without any issues. On one of my installations
I have used Oracle instant client as well.


AFAIK there are no issues with using 10g client dlls.

Make sure you use the correct version of ODP.NET for your Oracle client

In the end it appeared to be that the ORACLE_HOME env variable was missing. So
once this was added (pointing to D:\oracle\product\10.2.0\db_1) and the server
machine was restarted then the error no longer appeared.