Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-21
4
Medium Priority
?
499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Setting up LaraDock for Laravel

Learn how to set up LaraDock in a Laravel project - LaraDock gives us an easy way to run a Laravel application using Docker in a single command.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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…

715 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