Hi,

In my web application I am using OledbConnection to connect to Oracle DB.

Problem I am facing is when more than one users reach OledbDataAdapter.Fill statement, one of them get failed and .net throws an error saying

Datareader needs Open connection. Connection State is Open, Execute

My Code is

conn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=MyApp;User ID=aaaaa;Password=aaaaaaa"

if (conn.State != ConnectionState.Open)
{
if (conn.State != ConnectionState.Closed)
conn.Close();
conn.Open();
}

dtdptr = new OleDbDataAdapter(mySQL, conn);
dtSetMyAuctionToday = new DataSet();

dtdptr.Fill(dtSetMyAuctionToday);

I don't know how to resolve it. I think it is connection Pooling issue, I don't know how to use pooling.

Any help will be appreciated. My application is already in a production environment.

Thanks & Best Regards,