?
Solved

Urgent: Error accessing MySQL data (ASP.NET website) - production server only

Posted on 2008-10-21
4
Medium Priority
?
508 Views
Last Modified: 2008-10-26
Using VS 2008 SP1 with MySQL 5. Using DevArt's MyDirect.NET (latest version) to access the data.

Created a new, simple, asp.net web site. Created one new XSD dataset with one TableAdapter containing GetData. (I used the production server in my connectionstring, defined in the web.config.) Then I created one aspx page with a gridview which utilized GetData. On the local machine it runs perfectly.  Very simple website.

I uploaded all the files to the production server. When I go to the url I get this error. Any ideas?

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
0
Comment
Question by:RobertNZana
  • 3
4 Comments
 
LVL 20

Expert Comment

by:brwwiggins
ID: 22767578
Did you verify the asp.net version set for the website in IIS? I think by default it does 1.1

Open the IIS manager, right-click on the website or VD and go to properties. Double check the ASP.NET tab
0
 
LVL 9

Author Comment

by:RobertNZana
ID: 22768992
Using IIS Manager (IIS V7) in Windows Server 6 SP1.

In Application Pools it shows up as v2.0.  Should v3.5 show up as "v3.5" or not?

I DEFINITELY need to use v3.5.  Let me look at it and get back to you in a second.  Please stick with me on this thread because it's really important to me.  Thanks!
0
 
LVL 9

Accepted Solution

by:
RobertNZana earned 0 total points
ID: 22769254
Apparently the 3.0 and 3.5 are essentially extensions to the 2.0 system, and show as 2.0 in the IIS app pool display.

http://forums.iis.net/p/1147405/1861282.aspx

I think the problem is with MyDirect .NET provider, which gives me access to the MySql database.

Someone suggested that I manually add the provider to the web.config file, like this...
 <system.data>
  <DbProviderFactories>
   <add name="MyDirect .NET" invariant="CoreLab.MySql" description="CoreLab MyDirect .NET"
    type="CoreLab.MySql.MySqlDirectFactory, CoreLab.MySql" />
  </DbProviderFactories>
 </system.data>

But that didn't work either.  Any other ideas?
0
 
LVL 9

Author Comment

by:RobertNZana
ID: 22769568
Actually that did work.

I also had to do a...

<remove name="CoreLab.MySql" /> before the add

Thanks and I hope this is useful to others...
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
There is a wide range of advantages associated with the use of ASP.NET. This is why this programming framework is used to create excellent enterprise-class websites, technologies, and web applications.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question