RE: Security exception while opening an OleDBConnection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Lotus,
You can start out by ensuring the windows identity your ASP.NET app is
running under has full permissions on the folder the Excel workbook resides
in. If you want a quick test,
add an
<identity impersonate="true" userName="AdminAccount" password="pass" />
element to your web.config to make the app run under an Administrator
account temporarily. Normally this account would have full permissions so
it's a quick way to test if that's the issue.

Otherwise, it could be some anomalies in your connection string.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com




"CyberLotus" wrote:

Hi,

I've created a web application and through this I want to import Excel data
to database.
Following is the code that I've written,

*******************************************************************
string fileLocation = txtboxFileName.Text.ToString();
string sheetName = "Import";
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+fileLocation+";Extended Properties=Excel 8.0";
string strSQL = "select * from ["+sheetName+"$]";

OleDbConnection cn = new OleDbConnection(connectionString); // It's failing
here

cn.Open();
OleDbCommand cm = new OleDbCommand(strSQL,cn);
OleDbDataAdapter da = new OleDbDataAdapter(cm);
DataSet excelDS = new DataSet();
da.Fill(excelDS);
.....................
.....................
.....................
*******************************************************************

I've used OleDBConnection for reading the excel, but it's giving me a
Security Exception.
Here's the exception:

####################################################################
Server Error in '/PreSa' Application.
--------------------------------------------------------------------------------

Security Exception
Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.

Exception Details: System.Security.SecurityException: Request failed.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request failed.]
Try2.WebUserControl2.btnSend_Click(Object sender, EventArgs e) +0
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() +2112
System.Web.UI.Page.ProcessRequest() +217
System.Web.UI.Page.ProcessRequest(HttpContext context) +18

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300

####################################################################

Please help me as it's very urgent.

Thanks a ton.


Regards,
Lotus

.

Relevant Pages

  • Excel Open throws 0x800A03EC error
    ... I need to give permissions to Microsoft Excel Application which was missing ... I did the following to give Excel permissions. ... General Information ... Exception Type: System.Runtime.InteropServices.COMException ...
    (microsoft.public.office.developer.automation)
  • RE: Excel Open throws 0x800A03EC error
    ... I need to give permissions to Microsoft Excel Application which was missing ... I did the following to give Excel permissions. ... General Information ... Exception Type: System.Runtime.InteropServices.COMException ...
    (microsoft.public.office.developer.automation)
  • Re: Security.Exception
    ... Security Exception ... Exception Details: System.Security.SecurityException: That assembly does not ... >>Control to see if it's a permissions problem. ... >> Diego F. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Security exception while opening an OleDBConnection
    ... Also, I'm using ASPNET account. ... should have access to Excel File. ... Security Exception. ...
    (microsoft.public.dotnet.security)
  • Re: Security exception while opening an OleDBConnection
    ... CyberLotus have you given it the right permissions? ... and i posted a similar solution for MS access database. ... Security Exception. ...
    (microsoft.public.dotnet.framework.aspnet.security)