Hi everyone,
I have a problem with web service an Oracle.
I have this code:

---Start code---
XmlDocument inDoc = new XmlDocument ();
inDoc.Load(@"C:\HUBEAI\Normalizzatore\Transact\Code\CreditScoring\Esempi\FormatoInputNormalizzatore_output.xml");
string inputData = inDoc.InnerXml;

string connectionProvider = "NHibernate.Connection.DriverConnectionProvider";
string dialect = "NHibernate.Dialect.OracleDialect";
string connectionDriver = "NHibernate.Driver.OracleClientDriver";
string connectionString = @"Data Source=pgolractest.seat.it; User Id=XXX; Password=XXX; Persist Security Info=true; Pooling=false";
string confAssembly = "Seat.CreditScoring.Entities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b63b839fda4bc3d8";

NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration();
cfg.SetProperty(NHibernate.Cfg.Environment.ConnectionProvider, connectionProvider);
cfg.SetProperty(NHibernate.Cfg.Environment.Dialect, dialect);
cfg.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, connectionDriver);

cfg.SetProperty(NHibernate.Cfg.Environment.ConnectionString, connectionString);
Assembly entitiesAssembly = Assembly.Load(confAssembly);
cfg.AddAssembly(entitiesAssembly);
InputDbAccessLayerImpl dbAccess = new InputDbAccessLayerImpl(cfg);
InputData input = new InputData();
input.Input = inputData;
input.StartDate = DateTime.Now;
input.StopDate = DateTime.Now;
input.State='I';
dbAccess.InsertInputData (input);
---End code---

This code simply add a entry in a Oracle db (table InputData). It properly works if I run it in a console application.
If I run it in a web method of a web service, it returns this error: cannot open connection ---> NHibernate.ADOException: cannot open connection ---> NHibernate.ADOException: Could not create connection from Driver ---> System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
However I use the same driver with the same Oracle client version (9.2) from the same machine! If I use the same code changing the driver to SQL Server 2000, the web service works.
I can't understand why it does not work and I ask for your help.

Thanks,
Gionni

We have had similar problems due to invalid access rights on Oracle installation folder. Granting "Full access" to everyne, and specifyng "replace on child entitys" in advanced page has cured the problem, thought it might not be suitable in Your enviroment. (So You might want to figure out the minimum rights needed to grant for aspnet user)

Gert

Thanks a lot for your response. I was beating my head against the wall and you saved my life.

Thanks, Gionni