Solved

Security Exception (using mysql connector)

Posted on 2009-07-05
2
849 Views
Last Modified: 2012-05-07
ASP.NET website using MySql db and a connector I purchased (MyDirect.NET).

Local machine:  All works perfectly.

Deployed to GoDaddy ASP.NET web hosting.  I get this error:

----------------

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 for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' 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 for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
   System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) +0
   System.Security.CodeAccessPermission.Demand() +58
   System.Reflection.Assembly.get_Location() +70
   CoreLab.Common.ab.a(Assembly A_0) +32
   CoreLab.Common.ac.a(LicenseContext A_0, Type A_1, String& A_2, String& A_3, String& A_4) +2413
   CoreLab.Common.ac.a(LicenseContext A_0, Type A_1, String& A_2, Boolean& A_3, String& A_4, String& A_5) +33
   CoreLab.Common.ac.a(LicenseContext A_0, Type A_1, Boolean A_2) +181
   CoreLab.MySql.MySqlDirectFactory.CreateConnection() +64
   System.Data.Design.DataComponentMethodGenerator.AddConnectionMembers(CodeTypeDeclaration dataComponentClass) +56
   System.Data.Design.DataComponentMethodGenerator.AddMethods(CodeTypeDeclaration dataComponentClass, Boolean isFunctionsDataComponent) +106
   System.Data.Design.DataComponentGenerator.GenerateDataComponent(DesignTable designTable, Boolean isFunctionsComponent, Boolean generateHierarchicalUpdate) +819
   System.Data.Design.TypedDataSourceCodeGenerator.GenerateDataSource(DesignDataSource dtDataSource, CodeCompileUnit codeCompileUnit, CodeNamespace mainNamespace, String dataSetNamespace, GenerateOption generateOption) +485
   System.Data.Design.TypedDataSetGenerator.GenerateInternal(DesignDataSource designDS, CodeCompileUnit compileUnit, CodeNamespace mainNamespace, CodeDomProvider codeProvider, GenerateOption generateOption, String dataSetNamespace) +201

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3072

-------

In web.config I changed Trust level to Full but then I got another error:

-------

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: This configuration section cannot be used at this path.  This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file.

Source Error:


Line 55:       </system.net>
Line 56:       <system.web>
Line 57:           <trust level="Full" originUrl="" />
Line 58:
Line 59:             <!--

Source File: D:\Hosting\4616160\html\web.config    Line: 57

------------

Any ideas?
0
Comment
Question by:RobertNZana
2 Comments
 
LVL 22

Expert Comment

by:prairiedog
ID: 24788642
It seems that you asked the same question at their forum and your question was answered by the development team here: http://www.devart.com/forums/viewtopic.php?t=15239&sid=c99914a9662eb56a6bfc6f8d30fd1dac
0
 
LVL 9

Accepted Solution

by:
RobertNZana earned 0 total points
ID: 24788685
Yes, since no one responded, and it was pressing, I did ask it there.  The funny thing is that somehow, after reuploading the site and changing a few misc things, it began to work.  Go figure!  Thanks!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Creating and Managing Databases with phpMyAdmin in cPanel.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now