473,396 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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
6 5332
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
"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
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
"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
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Krusty276 | last post by:
I'm getting this error using sql plus Input is too long (> 2499 characters) - line ignored This is my command line on linux: /home/oracle/product/8.1.6/bin/sqlplus -s loader/loader@ecrmdb...
1
by: Kevin | last post by:
Help, I am running a pass through query to oracle from SQL server 2000 as follows; select * from openquery(nbsp, 'select * from FND_FLEX_VALUES') I have run this query through both DTS and...
9
by: Wally | last post by:
I am trying to display images from an Access 2000 database and I get an error "Invalid Parameter Used" when I execute the code line "picBLOB.Image = Image.FromStream(stmBLOBData)" in my Visual...
3
by: christianprogrammermilwaukee | last post by:
BASIC Settings PLEASE !! This New Company I'm with Sets their Default WebSite to a local Directory on "D" Yea I've been down the whole route reinstalling XP Pro,,, IIS 5.1 The .NET framework...
0
by: | last post by:
Hello NG! I try to call a WebService from a mobile device. The WebService should return a DataSet, so the call looks like mDataSet = mWebSrv.GetDataSet(<Params>) but instead of returning a...
8
by: Ravi Ambros Wallau | last post by:
Hey guys: What can I do when an "Error Creating Control" is displayed on the form (instead of the control), and a tooltip indicating the error never is displayed? Is there some log, some hidden...
1
by: Tom | last post by:
After completing my app, I moved it to the production server. It ran ok for two days on the production server. Then, I made a change to the login process, which forced a dynamic compile(I do...
0
by: DC | last post by:
The problem I'm using the .NET GridView and FormView objects for the first time and im getting the error "An OleDbParameter with ParameterName '@ID' is not contained by this...
23
by: deathtospam | last post by:
A day or two ago, I wrote a quick ASPX page with a CS codebehind using Visual Studio .NET 2005 -- it worked, I saved it and closed the project. Today, I came back to the project, reopened the...
0
by: kbelizabethtan | last post by:
i m using vb.net and mysql to create my project. when i save my data it apear the message that is Error = Only byte array and strings can be serialize by MySqlBinary how do i solve this...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.