Security Exception (using mysql connector)

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?
LVL 9
RobertNZanaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

prairiedogCommented:
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
RobertNZanaAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.