Security exception while opening an OleDBConnection

[CyberLotus]

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 connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source="+fileLo cation+";Extend ed Properties=Exce l 8.0";
string strSQL = "select * from ["+sheetName +"$]";

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

cn.Open();
OleDbCommand cm = new OleDbCommand(st rSQL,cn);
OleDbDataAdapte r da = new OleDbDataAdapte r(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 .SecurityExcept ion: 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:

[SecurityExcepti on: Request failed.]
Try2.WebUserCon trol2.btnSend_C lick(Object sender, EventArgs e) +0
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +2112
System.Web.UI.P age.ProcessRequ est() +217
System.Web.UI.P age.ProcessRequ est(HttpContext context) +18

System.Web.Call HandlerExecutio nStep.System.We b.HttpApplicati on+IExecutionSt ep.Execute() +179
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +87


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300

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

Please help me as it's very urgent.

Thanks a ton.
Regards,
Lotus

[Peter Bromberg [C# MVP]]

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="tr ue" userName="Admin Account" 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 connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source="+fileLo cation+";Extend ed Properties=Exce l 8.0";
string strSQL = "select * from ["+sheetName +"$]";

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

cn.Open();
OleDbCommand cm = new OleDbCommand(st rSQL,cn);
OleDbDataAdapte r da = new OleDbDataAdapte r(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 .SecurityExcept ion: 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:

[SecurityExcepti on: Request failed.]
Try2.WebUserCon trol2.btnSend_C lick(Object sender, EventArgs e) +0
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +2112
System.Web.UI.P age.ProcessRequ est() +217
System.Web.UI.P age.ProcessRequ est(HttpContext context) +18

System.Web.Call HandlerExecutio nStep.System.We b.HttpApplicati on+IExecutionSt ep.Execute() +179
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +87


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300

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

Please help me as it's very urgent.

Thanks a ton.
Regards,
Lotus

[Willy Denoyette [MVP]]

"CyberLotus " <Cy********@dis cussions.micros oft.com> wrote in message
news:D6******** *************** ***********@mic rosoft.com...
| 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 connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
| Source="+fileLo cation+";Extend ed Properties=Exce l 8.0";
| string strSQL = "select * from ["+sheetName +"$]";
|
| OleDbConnection cn = new OleDbConnection (connectionStri ng); // It's
failing
| here
|
| cn.Open();
| OleDbCommand cm = new OleDbCommand(st rSQL,cn);
| OleDbDataAdapte r da = new OleDbDataAdapte r(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 .SecurityExcept ion: 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:
|
| [SecurityExcepti on: Request failed.]
| Try2.WebUserCon trol2.btnSend_C lick(Object sender, EventArgs e) +0
| System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
|
|
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +57
| System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
| sourceControl, String eventArgument) +18
| System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
| System.Web.UI.P age.ProcessRequ estMain() +2112
| System.Web.UI.P age.ProcessRequ est() +217
| System.Web.UI.P age.ProcessRequ est(HttpContext context) +18
|
|
System.Web.Call HandlerExecutio nStep.System.We b.HttpApplicati on+IExecutionSt ep.Execute()
+179
| System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
| completedSynchr onously) +87
|
|
|
|
| --------------------------------------------------------------------------------
| Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
| Version:1.1.432 2.2300
|
| ############### ############### ############### ############### ########
|
| Please help me as it's very urgent.
|
| Thanks a ton.
|
|
| Regards,
| Lotus
|

Seems like you are loading and running this from a network share, right?
In that case you need to adjust your security policy settings, search MSDN
for details about caspol.exe, this utility can be used to set the correct
policy for your scenario.

Willy.

[Willy Denoyette [MVP]]

"Willy Denoyette [MVP]" <wi************ *@telenet.be> wrote in message
news:u3******** *****@TK2MSFTNG P14.phx.gbl...
|
||
|
| Seems like you are loading and running this from a network share, right?
| In that case you need to adjust your security policy settings, search MSDN
| for details about caspol.exe, this utility can be used to set the correct
| policy for your scenario.
|
| Willy.
|

Sorry should be "running this from an internet site". But the same policy
applies, your web service doesn't have sufficient trust to access the
(local/remote?) file (excel).

Willy.

[CyberLotus]

Hi Peter,

I tried with the quick test that you mentioned and there's no anomaly in the
connection string.
Please let me know what could be the issue.

Thanks.
"Peter Bromberg [C# MVP]" wrote:

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="tr ue" userName="Admin Account" 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 connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source="+fileLo cation+";Extend ed Properties=Exce l 8.0";
string strSQL = "select * from ["+sheetName +"$]";

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

cn.Open();
OleDbCommand cm = new OleDbCommand(st rSQL,cn);
OleDbDataAdapte r da = new OleDbDataAdapte r(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 .SecurityExcept ion: 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:

[SecurityExcepti on: Request failed.]
Try2.WebUserCon trol2.btnSend_C lick(Object sender, EventArgs e) +0
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +2112
System.Web.UI.P age.ProcessRequ est() +217
System.Web.UI.P age.ProcessRequ est(HttpContext context) +18

System.Web.Call HandlerExecutio nStep.System.We b.HttpApplicati on+IExecutionSt ep.Execute() +179
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +87


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300

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

Please help me as it's very urgent.

Thanks a ton.
Regards,
Lotus

[Willy Denoyette [MVP]]

System.Security .SecurityExcept ion has nothing to do with your
connectionstrin g, these kind of exceptions are code access security (CAS)
related. That is "where do you load" the executing asssembly from (e.i from
a network share/mapped drive) and what do you expect this code to do with
respect to security policy privileges. Please read all about CAS and the
Caspol utility in the framework dosc.
Willy.

"CyberLotus " <Cy********@dis cussions.micros oft.com> wrote in message
news:69******** *************** ***********@mic rosoft.com...
| Hi Peter,
|
| I tried with the quick test that you mentioned and there's no anomaly in
the
| connection string.
| Please let me know what could be the issue.
|
| Thanks.
|
|
| "Peter Bromberg [C# MVP]" wrote:
|
| > 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="tr ue" userName="Admin Account" 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 connectionStrin g = @"Provider=Micr osoft.Jet.OLEDB .4.0;Data
| > > Source="+fileLo cation+";Extend ed Properties=Exce l 8.0";
| > > string strSQL = "select * from ["+sheetName +"$]";
| > >
| > > OleDbConnection cn = new OleDbConnection (connectionStri ng); // It's
failing
| > > here
| > >
| > > cn.Open();
| > > OleDbCommand cm = new OleDbCommand(st rSQL,cn);
| > > OleDbDataAdapte r da = new OleDbDataAdapte r(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 .SecurityExcept ion: 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:
| > >
| > > [SecurityExcepti on: Request failed.]
| > > Try2.WebUserCon trol2.btnSend_C lick(Object sender, EventArgs e) +0
| > > System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
| > >
| > >
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +57
| > > System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
| > > sourceControl, String eventArgument) +18
| > > System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
+33
| > > System.Web.UI.P age.ProcessRequ estMain() +2112
| > > System.Web.UI.P age.ProcessRequ est() +217
| > > System.Web.UI.P age.ProcessRequ est(HttpContext context) +18
| > >
| > >
System.Web.Call HandlerExecutio nStep.System.We b.HttpApplicati on+IExecutionSt ep.Execute()
+179
| > > System.Web.Http Application.Exe cuteStep(IExecu tionStep step,
Boolean&
| > > completedSynchr onously) +87
| > >
| > >
| > >
| > >
| > --------------------------------------------------------------------------------

| > > Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
| > > Version:1.1.432 2.2300
| > >
| > > ############### ############### ############### ############### ########
| > >
| > > Please help me as it's very urgent.
| > >
| > > Thanks a ton.
| > >
| > >
| > > Regards,
| > > Lotus
| > >