The oracle .net client is a big pain to install and manage. So what experience have people got with alternatives?
(Telling the customer that you only support Sql Server is not always an option)
+1
A:
Why alternatives? The ODP.Net provider from Oracle works. I've provided some more details here. If there are any interesting requirements we could discuss further of course.
Alex Paven
2010-09-21 15:52:10
It may work after it has been installed, however installing it is a pain and often needs a oracle dba to get it working. It is also a large install with a 101 different config files.
Ian Ringrose
2010-09-21 16:05:34
Umm.. did you read the post I linked to? If you include ODP.Net in your project's output i.e. besides your .exe file, and if you include OCI as well, you don't need anything installed prior to your application connecting to Oracle.
Alex Paven
2010-09-21 16:36:33