By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,485 Members | 1,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,485 IT Pros & Developers. It's quick & easy.

URGENT: "Parser error" for all XSD datasets (production server only) - using ASP.NET and MySQL

P: n/a
Using ASP.NET 3.5 and MySQL (thru DevArt MyDirect.NET)...

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.

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: <?xml version="1.0" encoding="utf-8"?>
Line 2: <xs:schema id="dsCompanyTypes"
targetNamespace="http://tempuri.org/dsCompanyTypes.xsd"
xmlns:mstns="http://tempuri.org/dsCompanyTypes.xsd"
xmlns="http://tempuri.org/dsCompanyTypes.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
attributeFormDefault="qualified" elementFormDefault="qualified">
Line 3: <xs:annotation>

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
Oct 20 '08 #1
Share this Question
Share on Google+
6 Replies


P: n/a
No ideas? This is really holding up my project...

"Bobby Edward" <bo***@nobody.comwrote in message
news:OF**************@TK2MSFTNGP06.phx.gbl...
Using ASP.NET 3.5 and MySQL (thru DevArt MyDirect.NET)...

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.

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: <?xml version="1.0" encoding="utf-8"?>
Line 2: <xs:schema id="dsCompanyTypes"
targetNamespace="http://tempuri.org/dsCompanyTypes.xsd"
xmlns:mstns="http://tempuri.org/dsCompanyTypes.xsd"
xmlns="http://tempuri.org/dsCompanyTypes.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
attributeFormDefault="qualified" elementFormDefault="qualified">
Line 3: <xs:annotation>

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


Oct 21 '08 #2

P: n/a
"Bobby Edward" <bo***@nobody.comwrote in message
news:#M**************@TK2MSFTNGP05.phx.gbl...
No ideas? This is really holding up my project...
I have no clue. I don't use Web Sites.

All I have to offer is some diagnostic advice you've probably already taken.
This seems to take place when the DataSet is being "parsed". Exactly when
does it happen? When you view any page? A particular page? Does it only
happen when you access the database?

If it happens without you accessing the database, then I recommend that you
try to create a minimal web site that reproduces the problem. This site, for
instance, would not have any reference to MySQL if that was not necessary to
reproduce the problem.

Such a site will be easy to zip up, either to post here, or on
http://connect.microsoft.com/visualstudio/, or to send to Microsoft Product
Support.
--
John Saunders | MVP - Connected System Developer

Oct 21 '08 #3

P: n/a
Thanks. It happens for any ASPX page, even non data pages.

I created a minimal website (one XSD dataset, one BLL class, one aspx page)
and it still happens. :(

I just can't afford MS product support. They are too expensive. Any
further suggestions would be appreciated... There are LOTS of really smart
people in this newsgroup....

"John Saunders" <no@dont.do.that.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
"Bobby Edward" <bo***@nobody.comwrote in message
news:#M**************@TK2MSFTNGP05.phx.gbl...
>No ideas? This is really holding up my project...

I have no clue. I don't use Web Sites.

All I have to offer is some diagnostic advice you've probably already
taken. This seems to take place when the DataSet is being "parsed".
Exactly when does it happen? When you view any page? A particular page?
Does it only happen when you access the database?

If it happens without you accessing the database, then I recommend that
you try to create a minimal web site that reproduces the problem. This
site, for instance, would not have any reference to MySQL if that was not
necessary to reproduce the problem.

Such a site will be easy to zip up, either to post here, or on
http://connect.microsoft.com/visualstudio/, or to send to Microsoft
Product Support.
--
John Saunders | MVP - Connected System Developer

Oct 21 '08 #4

P: n/a
"Bobby Edward" <bo***@nobody.comwrote in message
news:Oh**************@TK2MSFTNGP03.phx.gbl...
Thanks. It happens for any ASPX page, even non data pages.

I created a minimal website (one XSD dataset, one BLL class, one aspx
page) and it still happens. :(

I just can't afford MS product support. They are too expensive. Any
further suggestions would be appreciated... There are LOTS of really
smart people in this newsgroup....
That may be true, but _this_ smart person never uses a Web Site "project",
so would never have experienced this. (I'll leave to the readers the
question of whether the fact that I don't use Web Site "projects" might not
be one of the things that qualifies me as "smart").

How about one XSD, one page, and no BLL?

How about a very simple XSD: one table, with one column?

If that still shows the problem, then it's a bug, and not something that PSS
could help you with anyway. In that case, report the bug at
http://connect.microsoft.com/visualstudio/. That's free, and connects
directly with the product group.

P.S. One option would be to use a Web Application Project instead of a Web
Site "project".
--
John Saunders | MVP - Connected System Developer

Oct 21 '08 #5

P: n/a
"John Saunders" <no@dont.do.that.comwrote in message
news:e$**************@TK2MSFTNGP04.phx.gbl...
That may be true, but _this_ smart person never uses a Web Site "project",
so would never have experienced this. (I'll leave to the readers the
question of whether the fact that I don't use Web Site "projects" might
not be one of the things that qualifies me as "smart").
No, you definitely are smart! LOL
>
How about one XSD, one page, and no BLL?
Tried that with the same results.
>
How about a very simple XSD: one table, with one column?
Good idea. I did this but it resulted in the same thing.
If that still shows the problem, then it's a bug, and not something that
PSS could help you with anyway. In that case, report the bug at
http://connect.microsoft.com/visualstudio/. That's free, and connects
directly with the product group.
If this is the case, and I call Microsoft, do you know if they will charge
me for support?

I am using VS2008 SP1 with MySQL 5. I'm actually using DevArt's
MyDirect.NET to access the database (http://www.devart.com/mysqlnet/). Do
you think it could be a bug with their product?
P.S. One option would be to use a Web Application Project instead of a Web
Site "project".
Interesting. I never considered that they were different.

Thanks so much for your help. Any further suggestions are very much
welcomed! Take care....
Oct 21 '08 #6

P: n/a
FIX:

Register the data provider in the web.config file. Add this section to it:


<configuration>

....

<appSettings/>

<system.data>
<DbProviderFactories>
<add name="MyDirect .NET" invariant="CoreLab.MySql" description="CoreLab
MyDirect .NET"
type="CoreLab.MySql.MySqlDirectFactory, CoreLab.MySql" />
</DbProviderFactories>
</system.data>

....

</configuration>


Oct 21 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more ASP.NET Questions on Bytes