Solved

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

Posted on 2008-10-21
4
491 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ASP.NET MVC identity 6 27
PHP insert data in to database... this is not letting me in insert data...please help! 7 42
.NET 2008 VB and C# 6 28
Save ms data to server side. 19 46
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 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