Dataset Parser Error
Dataset Parser Error
I have been using the professional version of the driver for a couple days now without any problems. However I just recently started using datasets in my project and I ran into this problem.
Everything works great on my development server however when I try and upload it to my ISP server I get this error: Am I forgetting to copy a DLL over or something alongs those lines?
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/dsUsers.xsd Line: 1
-------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
Everything works great on my development server however when I try and upload it to my ISP server I get this error: Am I forgetting to copy a DLL over or something alongs those lines?
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/dsUsers.xsd Line: 1
-------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
The errors takes place after I add a dataset to the project. Everything works fine on my home PC, but when I update to my web host I get the error listed above.
1. I create a project with a blank aspx page.
2. I create a dataset using the mysql provider
3. Run it on my home PC and everything works.
4. Copy it to my web hosting site
5. Try and access the blank page and I get the error message listed above.
Just to check I was able to create a dataset with the MS SQL provider without the error message coming up.
I have tried copying up different combinations of the dll files without luck.
This is what is currently in my bin folder:
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
1. I create a project with a blank aspx page.
2. I create a dataset using the mysql provider
3. Run it on my home PC and everything works.
4. Copy it to my web hosting site
5. Try and access the blank page and I get the error message listed above.
Just to check I was able to create a dataset with the MS SQL provider without the error message coming up.
I have tried copying up different combinations of the dll files without luck.
This is what is currently in my bin folder:
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
The project is in asp.net so I copy all the files from the project's IIS folder and the included sub folders. The dataset files are in the apps_code folder.
Then I try and access the aspx file through the web browser (default.aspx) and I get the error.
If I remove the dataset files from the project default.aspx file will open. If any dataset is present using the core mysql provider the error message appears when I try and access the aspx file through the web browser.
So what I am doing is creating an IIS web project in visual studio 2005 with the default settings (default web.config, blank default.aspx) then creating a dataset using the core labs mysql provider. I do this on my home PC and it runs great.
Then I copy the project folder to my web host. Copy the DLL files (CoreLab.Data.dll, CoreLab.MySql.dll, CoreLab.MySql.Web.dll) to bin. Then try and access the default.aspx file through internet explorer (this step on a project that I have not added the dataset to) and I get the error message.
Then I try and access the aspx file through the web browser (default.aspx) and I get the error.
If I remove the dataset files from the project default.aspx file will open. If any dataset is present using the core mysql provider the error message appears when I try and access the aspx file through the web browser.
So what I am doing is creating an IIS web project in visual studio 2005 with the default settings (default web.config, blank default.aspx) then creating a dataset using the core labs mysql provider. I do this on my home PC and it runs great.
Then I copy the project folder to my web host. Copy the DLL files (CoreLab.Data.dll, CoreLab.MySql.dll, CoreLab.MySql.Web.dll) to bin. Then try and access the default.aspx file through internet explorer (this step on a project that I have not added the dataset to) and I get the error message.
Update:
I uninstall the provider and the developer tools on my home computer.
The same error as in the first message now comes up.
I put these 4 files in the bin directory.
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
App_Licenses.dll
The error still comes up.
I reinstall just the provider and not developer tools. The error goes away. However I unable to install the exe on my web host so this is not a solution for me.
I uninstall the provider and the developer tools on my home computer.
The same error as in the first message now comes up.
I put these 4 files in the bin directory.
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
App_Licenses.dll
The error still comes up.
I reinstall just the provider and not developer tools. The error goes away. However I unable to install the exe on my web host so this is not a solution for me.
1. Create a web site using visual studio 2005
web.config
default.aspx (this is a blank page without any controls)
Are created automatically
2. Right click on the project select add dataset. Visual studio says that the dataset should be in Apps_code and asks if it can move it there. I click yes.
3. Choose the MySQL Database (MySQLDirect .NET) database provider and type in the information.
4. Click test connection (success)
5. The table adapter comes up. Select all the fields from the users tables. Click ok.
6. Copy
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
To the bin folder.
7. Set Default.aspx as the default start page and click play in visual studio. The blank page is displayed. In my real project I actually use the dataset tableadapter functions to query the database and it works.
8. Copy everything including the bin files to my web host.
9 Go to internet explorer and try and access default.aspx.
10 I receive the same error as in the first post.
If I delete the dataset from my host everything works. So there is something different involving my computer and the host computer in regards to the dataset file.
I will email you a copy of the project with a working connection to the database.
web.config
default.aspx (this is a blank page without any controls)
Are created automatically
2. Right click on the project select add dataset. Visual studio says that the dataset should be in Apps_code and asks if it can move it there. I click yes.
3. Choose the MySQL Database (MySQLDirect .NET) database provider and type in the information.
4. Click test connection (success)
5. The table adapter comes up. Select all the fields from the users tables. Click ok.
6. Copy
CoreLab.Data.dll
CoreLab.MySql.dll
CoreLab.MySql.Web.dll
To the bin folder.
7. Set Default.aspx as the default start page and click play in visual studio. The blank page is displayed. In my real project I actually use the dataset tableadapter functions to query the database and it works.
8. Copy everything including the bin files to my web host.
9 Go to internet explorer and try and access default.aspx.
10 I receive the same error as in the first post.
If I delete the dataset from my host everything works. So there is something different involving my computer and the host computer in regards to the dataset file.
I will email you a copy of the project with a working connection to the database.
To deploy applications written with MySQLDirect .NET you should register run-time assemblies CoreLab.MySql.dll and CoreLab.Data.dll at Global Assembly Cache (GAC) for appropriate framework or place them in the folder of your application (Bin folder for web projects).
When deploying ASP.NET website applications it is also necessary to have CoreLab.MySql.Web.dll and App_Licenses.dll assemblies available.
When deploying ASP.NET website applications it is also necessary to have CoreLab.MySql.Web.dll and App_Licenses.dll assemblies available.
I followed these instructions step by step. I cannot register items to the GAC for my web host so I go the dll route and it does not work. Are you able to get this working on a clean machine with just those 4 dll files with a dataset added to the project using visual studio rather then using the dataset wizard that comes with the core labs tools?
I just tried this on a friends computer and it didn't work there either if I didn't install the core labs mysql driver and developer tools. If I install the driver the program works on his computer.
This leads me to believe that the exe file mysqlnet400pro2.exe is doing more then just registering these items in the gac. This is three seperate computers that I am having this problem on.
I just tried this on a friends computer and it didn't work there either if I didn't install the core labs mysql driver and developer tools. If I install the driver the program works on his computer.
This leads me to believe that the exe file mysqlnet400pro2.exe is doing more then just registering these items in the gac. This is three seperate computers that I am having this problem on.
When I create the dataset in visual studio 2005 it has me put the dataset in the apps_code folder. The files in the apps_code folder are automatically compiled at runtime. So when I try and access the default.aspx via internet explorer it crashes the program while trying to compile the dataset.
I just sent an email with the project in an attached file zip file.
I just sent an email with the project in an attached file zip file.