Search found 23 matches

by robertnzana
Mon 06 Jul 2009 19:25
Forum: dotConnect for MySQL
Topic: App_Licenses.dll - problem after upgrading
Replies: 1
Views: 2935

App_Licenses.dll - problem after upgrading

I ran the Upgrade Wizard with no errors.

But now I get a slew of errors including...

-----

Could not load file or assembly 'App_Licenses' or one of its dependencies. The module was expected to contain an assembly manifest.

-----

How or where do I find or generate this file? Should it use the same one as before? Please help.

----

Under License Info there is one red X:
Could not load file or assembly '4104 bytes loaded from Devart.Data.Design, Version=5.0.1.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. An attempt was made to load a program with an incorrect format.

-----

Devart.Data.Design.dll is in the bin folder. In fact I copied everything from the C:\Program Files\Common Files\Devart\dotConnect\5.00\Net2 to the bin folder.

Thanks.
by robertnzana
Mon 06 Jul 2009 03:05
Forum: dbForge for MySQL
Topic: Lost connection to MySQL server during query
Replies: 14
Views: 16676

mysql server connection always gets lost

How do you set the timeout in the web.config?
by robertnzana
Sun 05 Jul 2009 10:51
Forum: dotConnect for MySQL
Topic: Security Exception (shared hosting)
Replies: 6
Views: 3762

Security Exception (shared hosting)

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 from an inherited configuration file.

Source Error:


Line 55:
Line 56:
Line 57:
Line 58:
Line 59: <!--

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

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

Any ideas?
by robertnzana
Wed 22 Oct 2008 13:47
Forum: dotConnect for MySQL
Topic: How add providers to web.config
Replies: 2
Views: 2559

I apologize for the ambiguity. The problem was that the role provider did not have an application name. For some reason it worked locally but not on the production server. It’s fixed now. Thanks as usual! :)
by robertnzana
Tue 21 Oct 2008 19:04
Forum: dotConnect for MySQL
Topic: How add providers to web.config
Replies: 2
Views: 2559

How add providers to web.config

To get my web app to read basic data correctly I had to add an entry in my web.config for CoreLab.MySql:







General db access works fine now.

I am using ASP.NET built-in membership/roles/profiles. It works fine on my development machine, but not on the production server. Do I have to add similar entries for the membership/roles/profiles stuff? If so, how do I do this?

In my web.config I set it up like this...














-->











by robertnzana
Tue 21 Oct 2008 18:58
Forum: dotConnect for MySQL
Topic: "Parser error" for all XSD datasets (production serv
Replies: 1
Views: 2540

I fixed it by adding the data provider in the web.config file. Add this section to it:


...







...
by robertnzana
Mon 20 Oct 2008 13:03
Forum: dotConnect for MySQL
Topic: "Parser error" for all XSD datasets (production serv
Replies: 1
Views: 2540

"Parser error" for all XSD datasets (production serv

Using ASP.NET 3.5 and MySQL (thru DevArt MyDirect.NET)...

When I developed my XSD datasets I was using "localhost". But, on my production server I want to use the production database. I changed all the connection strings in the web.config before I copied up the source files.

Now, on the production server I get a "Parser Error" for every XSD dataset. It works perfect on my dev machine. But, on the production server I get the error.

Again, to troubleshoot the issue I went back to my dev machine and changed all the connectionstrings from localhost to the remote/production server db and made sure everything works fine. I then uploaded all the files to the production server and this is the error I get... (It happens with all my XSD datasets...)

Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error
details and modify your source file appropriately.

Parser Error Message: Failed to generate code. Exception of type
'System.Data.Design.InternalException' was thrown.

Source Error:
Line 1:
Line 2:
Line 3:

Source File: /App_Code/DAL/dsCompanyTypes.xsd Line: 1

Version Information: Microsoft .NET Framework Version:2.0.50727.3053;
ASP.NET Version:2.0.50727.3053
by robertnzana
Mon 20 Oct 2008 12:50
Forum: dotConnect for MySQL
Topic: Cant deploy site - Configuration Error
Replies: 2
Views: 2353

I fixed it by searching my PC for the DLL then copying that one into the bin directory. It seems to fix it. I'm wondering why it wasn't included with the others. Oh well... Thanks.
by robertnzana
Fri 17 Oct 2008 23:58
Forum: dotConnect for MySQL
Topic: Cant deploy site - Configuration Error
Replies: 2
Views: 2353

Cant deploy site - Configuration Error

I created an ASP.NET website using the latest version of MyDirect.NET. All is fine locally.

My licenses.licx file consists of this line:
CoreLab.MySql.MySqlConnection, CoreLab.MySql, Version=4.85.36.0, Culture=neutral, PublicKeyToken=09af7300eec23701

Before I copied all the files to the server I did a "Build Runtime Licenses".

I then uploaded all the source files (including licenses,licx, app_licenses.dll, etc...) to the webserver. Now when I open the website on the internet I get this error. Any ideas why?

Error:

Server Error in '/' Application.
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: Could not load file or assembly 'CoreLab.Data.Design, Version=4.70.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The system cannot find the file specified.

Source Error:


Line 98:
Line 99:
Line 100:
Line 101:
Line 102:


Source File: C:\inetpub\wwwroot\mysite\web.config Line: 100

Assembly Load Trace: The following information can be helpful to determine why the assembly 'CoreLab.Data.Design, Version=4.70.24.0, Culture=neutral, PublicKeyToken=09af7300eec23701' could not be loaded.


WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
by robertnzana
Mon 22 Sep 2008 16:36
Forum: dotConnect for MySQL
Topic: DataSet Manager Empty???
Replies: 9
Views: 4888

I am running the latest version of MyDirect as you have suggested. The DataSet Manager is always empty, regardless of what I do.... :(
by robertnzana
Mon 22 Sep 2008 11:41
Forum: dotConnect for MySQL
Topic: DataSet Manager Empty???
Replies: 9
Views: 4888

Whats the best way to update MyDirect.NET? Do an uninstall/reinstall or just reference the newest DLL? What is the latest version and where can I download it?
by robertnzana
Fri 19 Sep 2008 11:24
Forum: dotConnect for MySQL
Topic: DataSet Manager Empty???
Replies: 9
Views: 4888

Shalex wrote:If you add a DataSet instance to Form Designer, it appears in DataSet Manager too. Please try the steps mentioned above. If the problem persists, let us know.
You can learn more about the benefits of using DataSet Manager here: http://www.devart.com/mysqlnet/docs/ | Database Application Development Concepts | Using DataSet Manager.
For some reason I can't get any dataset to appear in the manager, regardless of how I create the dataset (either thru the wizard or thru the standard way). It's always empty.
by robertnzana
Thu 18 Sep 2008 16:46
Forum: dotConnect for MySQL
Topic: DataSet Manager Empty???
Replies: 9
Views: 4888

I'm talking about the "DataSet Manager". It's always empty. I'm not talking about the form designer. Any ideas? Thanks.

Also, of what benefit is the DataSet Manager? It seems that the Solutions Explorer lists the DataSet's as well.
by robertnzana
Tue 16 Sep 2008 20:43
Forum: dotConnect for MySQL
Topic: DataSet Manager Empty???
Replies: 9
Views: 4888

DataSet Manager Empty???

I used the dataset manager to add a new dataset. When I was done it showed up in the Solution Explorer but not in the dataset manager, even AFTER I hit refresh and restarted VS2008.

Any idea why????

Thanks.