error reading excel using OleDb

[Abel]

Hi
I try to execute an sample how to read and write excel sheets using OleDb
When opens the connection, the objConn.Open gave me this error:
"Request for the permission of type 'System.Data.Ol eDb.OleDbPermis sion,
System.Data, Version=2.0.0.0 , Culture=neutral ,
PublicKeyToken= b77a5c561934e08 9' failed."
And appears the following message:
System.Exceptio n {System.Securit y.SecurityExcep tion}
Any idea to solve this error?
I work with VS 2005, using C#
TIA
Abel

[Nicholas Paldino [.NET/C# MVP]]

Are you doing this in ASP.NET perhaps, and trying to access an Excel
sheet on a network share, or on a part of the drive that ASPNET doesn't have
access to?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Abel" <Ab**@discussio ns.microsoft.co mwrote in message
news:89******** *************** ***********@mic rosoft.com...

Hi
I try to execute an sample how to read and write excel sheets using OleDb
When opens the connection, the objConn.Open gave me this error:
"Request for the permission of type 'System.Data.Ol eDb.OleDbPermis sion,
System.Data, Version=2.0.0.0 , Culture=neutral ,
PublicKeyToken= b77a5c561934e08 9' failed."
And appears the following message:
System.Exceptio n {System.Securit y.SecurityExcep tion}
Any idea to solve this error?
I work with VS 2005, using C#
TIA
Abel

[sloan]

I'd concur.

Permissions on the file, usually because of an asp.net environment.

Also, you have to be very anal with the connection string with excel. Every
space and ; matters.

"Abel" <Ab**@discussio ns.microsoft.co mwrote in message
news:89******** *************** ***********@mic rosoft.com...

Hi
I try to execute an sample how to read and write excel sheets using OleDb
When opens the connection, the objConn.Open gave me this error:
"Request for the permission of type 'System.Data.Ol eDb.OleDbPermis sion,
System.Data, Version=2.0.0.0 , Culture=neutral ,
PublicKeyToken= b77a5c561934e08 9' failed."
And appears the following message:
System.Exceptio n {System.Securit y.SecurityExcep tion}
Any idea to solve this error?
I work with VS 2005, using C#
TIA
Abel

[Abel]

Nicholas
This is my code:
Is a class program, to process in backoffice

public System.Data.Dat aSet GetDataFromExce lFile(String File_name) {
try {
string strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;";
strConn += "Data Source= " + File_name + "; Extended Properties=Exce l
8.0;HDR=Yes;IME X=1";
OleDbConnection ObjConn = new OleDbConnection (strConn);
====here fails => ObjConn.Open();
OleDbCommand ObjCmd = new OleDbCommand("S ELECT * FROM [ExcelFileTest$]",
ObjConn);
OleDbDataAdapte r objDA = new OleDbDataAdapte r();
objDA.SelectCom mand = ObjCmd;
DataSet ObjDataSet = new DataSet();
objDA.Fill(ObjD ataSet);
ObjConn.Close() ;
return ObjDataSet;
} catch(Exception excepcion) {
return null;
}
}

"Nicholas Paldino [.NET/C# MVP]" wrote:

Are you doing this in ASP.NET perhaps, and trying to access an Excel
sheet on a network share, or on a part of the drive that ASPNET doesn't have
access to?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Abel" <Ab**@discussio ns.microsoft.co mwrote in message
news:89******** *************** ***********@mic rosoft.com...

Hi
I try to execute an sample how to read and write excel sheets using OleDb
When opens the connection, the objConn.Open gave me this error:
"Request for the permission of type 'System.Data.Ol eDb.OleDbPermis sion,
System.Data, Version=2.0.0.0 , Culture=neutral ,
PublicKeyToken= b77a5c561934e08 9' failed."
And appears the following message:
System.Exceptio n {System.Securit y.SecurityExcep tion}
Any idea to solve this error?
I work with VS 2005, using C#
TIA
Abel

[Abel]

Sloan
See my answer to Nicholas, this isnt an ASP Program, is winforms
Yo can see my code
This is an environment problem
You can see on the stacktrace:

StackTrace " at System.Security .CodeAccessSecu rityEngine.Chec k(Object
demand, StackCrawlMark& stackMark, Boolean isPermSet)\r\n at
System.Security .PermissionSet. Demand()\r\n at
System.Data.Com mon.DbConnectio nOptions.Demand Permission()\r\ n at
System.Data.Ole Db.OleDbConnect ion.PermissionD emand()\r\n at
System.Data.Ole Db.OleDbConnect ionFactory.Perm issionDemand(Db Connection
outerConnection )\r\n at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)\r\n at
System.Data.Ole Db.OleDbConnect ion.Open()\r\n at
ProcessExcelFil e.Form1.GetData FromExcelFile(S tring File_name)"
Understand?
Regards
Abel

"sloan" wrote:

I'd concur.

Permissions on the file, usually because of an asp.net environment.

Also, you have to be very anal with the connection string with excel. Every
space and ; matters.

"Abel" <Ab**@discussio ns.microsoft.co mwrote in message
news:89******** *************** ***********@mic rosoft.com...

Hi
I try to execute an sample how to read and write excel sheets using OleDb
When opens the connection, the objConn.Open gave me this error:
"Request for the permission of type 'System.Data.Ol eDb.OleDbPermis sion,
System.Data, Version=2.0.0.0 , Culture=neutral ,
PublicKeyToken= b77a5c561934e08 9' failed."
And appears the following message:
System.Exceptio n {System.Securit y.SecurityExcep tion}
Any idea to solve this error?
I work with VS 2005, using C#
TIA
Abel