Oracle and udlFiles

Hi friends.

I have one application that uses the OleDbConnection object to connect to a
Oracle server. The connection strings is stored in a udl file.

Here is the connection string of the udl file ->
ChunkSize=10000;Password=xxx;Persist Security
Info=True;Provider=OraOLEDB.Oracle;User ID=xxx;Data Source=xxx;

When I open the udl file and test through the Windows it connects ok. But when I
run the applicaton with the connection string above the program does not respond
and no throws exceptions when it tries to open the database connection. In the
EventViewer there is a message saying that the application pool had crashed.

Some idea??

Thanks a lot

Rodrigo

Sorry friends yesterday I didn't explain the problem very well.

The problem occurs with one Asp.net application. Today I realized another test,
I created a WindowsForms application and put the same connection string I posted
early.

The code of the windows forms application that works well.

OleDbConnection oleDbConnection = new
OleDbConnection("ChunkSize=10000;Password=xxx;Persist Security
Info=True;Provider=OraOLEDB.Oracle;User ID=xxx;Data Source=xxx;");
oleDbConnection.Open();
MessageBox.Show("Connection Openned");
oleDbConnection.Close();
MessageBox.Show("Connection Closed");

The code of the Asp.net application that "craches".


OleDbConnection oc = new
OleDbConnection("ChunkSize=10000;Password=xxx;Persist Security
Info=True;Provider=OraOLEDB.Oracle;User ID=xxx;Data Source=xxx;");
try {
Response.Write("Before connection");
oc.Open();
Response.Write("Connected");
}
catch (Exception ex) {
//Write the exception in a txt file.
}
finally {
oc.Close();
}


When I run the Asp.net application the execution stops in the line with the
response "Before Connection" and exception is throw. In the windows
EventViewer there is a message

"A process serving application pool '.NET 2.0' suffered a fatal
communication error with the World Wide Web Publishing Service. The process id
was '5072'.".

Anyone knows what can I do to solve this problem? Can be a problem with
permissions?

Thanks a lot.

Rodrigo

Hi.
Today I realized another test. I granted FullControl to the EveryOne in the
Oracle installation folder.

Now the error I am receiving is "The 'OraOLEDB.Oracle' provider is not
registered on the local machine. "

I had installed the Oracle Client and as I sad before the windows application
that uses the same connection string is working well.

Any suggestion will be appreciated.

Thanks a lot.

Rodrigo.

OLE DB, OleDbConnection (.NET)
 
Standard security
This connection string uses a provider from Microsoft.  
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

 
 
Trusted connection 
  
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated
Security=Yes; 
 

Standard Security
This connection string uses a provider from Oracle.  
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=myUsername;Password=myPassword; 
 

Trusted Connection 
  
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1; 

TNS-less connection string
  
Provider=OraOLEDB.Oracle;Data
Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHo
st)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User
Id=myUsername;Password=myPassword;