Oracle Connection Error in ASP.Net

Jan 24 2005 4:30 AM
Unable to load DLL (oci.dll) Error giving in ASP.net (WebForm) when i try to connect oracle. When i write same code in vb.net (windows form), it is functioning. pls guide me, how to remove error. Server Error in '/WebApplication2' Application. -------------------------------------------------------------------------------- Unable to load DLL (oci.dll). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.DllNotFoundException: Unable to load DLL (oci.dll). Source Error: Line 26: Try Line 27: Con = New OracleConnection("user id=abc; Password=xyz;data source=envdb") Line 28: Con.Open() Line 29: strSQL = "select max(serial_number) from vehicle_arrival" Line 30: CMD = New OracleCommand(strSQL, Con) Source File: c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx.vb Line: 28 Stack Trace: [DllNotFoundException: Unable to load DLL (oci.dll).] System.Data.OracleClient.DBObjectPool.GetObject(Boolean& isInTransaction) +466 System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, Boolean& isInTransaction) +165 System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) +836 System.Data.OracleClient.OracleConnection.Open() +32 WebApplication2.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication2\WebForm1.aspx.vb:28 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1263 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0